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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
That appears to do the trick, thank you again @Genevieve P. !
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives