Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Freeze date
Is there a way to freeze a date =today() if a date field is controlled by a check box field once 24 hours passes? If check box checked = today.
Excel suggests using vba. I am not certain if there is a way in SS to do this type of function without the date changing.
Thoughts...suggestions?
Comments
-
Dean,
Check out this thread:
https://community.smartsheet.com/discussion/formula-selecting-checkbox-will-populate-completion-date
and let us know if that is what you are looking for.
I think it might be close, but there is a nuance to your wording that may require more clarification.
Craig -
Thank you. I will investigate.
-
Good morning.
Just to let Craig and others know who are trying to accomplish the same thing.....Criag's idea does indeed work well for freezing a date.
Thanks,
Dean
-
Sweet!
Craig
-
Update:
I do this now using Zapier (www.zapier.com)
I have a Zap that watches for an empty date column and a completion check box - when the check box is checked by the user, today's date is entered into the date column.
Later, if someone makes another change elsewhere in the row, which triggers the Zap, it does not do anything because the date column is not empty.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives