Is there a way to record date to an individual cell and not an entire column?
Hello,
I am attempting to use the Record Date automation to force my sheets to refresh automatically every day, early in the morning. This is to ensure that equations I have using Today(), refresh with today's date. Otherwise on my report pages and dashboards, tasks show an incorrect deadline status based on the old Today() function.
I've found that if I use a hidden column and 'record date' that I am able to refresh the sheets daily. The only problem is that I also use a formula for 'complete date' when a 'complete' box in the column prior is selected. If any changes are made to the entire row after this box is selected, it updates to that day (another Today() equation).
Because of this I am wondering if I can have the 'Record a date' function ONLY populate a single cell (first row, last column for example) that won't trigger every row to update?
Otherwise I'll have to make the complete date manual entry and keep record date automation to still populate every spreadsheet as this functionality has more utility than automatically updating complete date.
Thank you in advance.
Best Answer
-
Hi @CK17
Yes, this is possible!
You'll want to have a row that you know will always stay in the sheet which contains a Unique Value... for example a header row with the project name. Or, you could create a Helper Row at the top that you lock to ensure no one makes changes.
Then you can use a Condition Block in your workflow to say only run if the Cell with your unique value contains the "unique value", like so:
See: Condition Blocks: Filter What Your Automated Workflows Send
Cheers,
Genevieve
Answers
-
Hi @CK17
Yes, this is possible!
You'll want to have a row that you know will always stay in the sheet which contains a Unique Value... for example a header row with the project name. Or, you could create a Helper Row at the top that you lock to ensure no one makes changes.
Then you can use a Condition Block in your workflow to say only run if the Cell with your unique value contains the "unique value", like so:
See: Condition Blocks: Filter What Your Automated Workflows Send
Cheers,
Genevieve
-
That appears to do the trick, thank you again @Genevieve P. !
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives