Skip to main content
Christina_Jarosz
Level 9
Dec 1, 2022 3:47 PM UTC
Solved

Column that displays date report was run?

Is there a way to add in a column to any report of (right now) so that when we create a report and export it, it shows the date in a column?

i.e. I want to be able to see what you'd see in the title of a file, so when I'm looking in an excel document I can know when the report was run/exported.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Doug_Den_Hoed_AtAppStore
Doug_Den_Hoed_AtAppStoreAccepted solution
Community Advisor
Jan 25, 2023 9:51 PM UTC

Ah ok, I see what you're looking for. I don't know how to do that straight from Workfront. I wonder if maybe @doug_den_hoed__atappstore has an idea that would work for you - any thoughts, Doug?


 

Thanks for the tag (and the challenge) @sheri_whitten: yes, I did figure out a solution.

 

@christina_jarosz, to make a view include the current date and time (for exporting purposes), I invite you to add a column with the following text mode:

 

valueexpression=$$NOW valueformat=fullAtDate displayname=Current Date And Time

 

Which will then look like this:

 

 

Regards,

Doug

 

cc: note to self @doug_den_hoed__atappstore 

 

Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.

6 replies

Community Advisor
Dec 5, 2022 1:24 PM UTC

We use the Last Viewed By: Name and the Last Viewed Date - these are native fields in the Report report type. Is that what you're looking for?

Translate
Christina_Jarosz
Level 9
Dec 6, 2022 1:14 PM UTC

Thanks Sheri! I'm looking to display the time/date stamp of the current minute.

 

I want to be able to see, on an excel in a column, this report was exported on xyz date at xyz time.

 

The reports may have been viewed/edited etc multiple times. But if I am running multiple reports, I want to know that 'this data was pulled on Monday, 12/06 or Thursday, 12/01 for example. 

Translate
Community Advisor
Dec 7, 2022 8:43 PM UTC

Ah ok, I see what you're looking for. I don't know how to do that straight from Workfront. I wonder if maybe @doug_den_hoed__atappstore has an idea that would work for you - any thoughts, Doug?

Translate