Formula to enter a date based on the value and activity date of another column
Hi all,
If Column A has a check mark, is it possible to enter a date in Column B to show the date column A was checked?
Thanks
Answers
-
Hi @MarianneD617,
You can create an automation on your sheet with the following details:
Just choose the name of your date column (Date Closed) in your action block at the bottom where it says "Record a date".
I hope this helps!
Regards,
-
I hope you're well and safe!
To add to Sing's excellent advice/answer.
If you'd like to have the time, you could use the method I developed below.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
That helps moving forward.
Is there a way to pull in a past date or will the workflow only update the cells based on new activity?
For cells already checked, I'd like to pull in the date the check was entered in the cell. Is that possible?
Thanks
-
@MarianneD617 @Marianna I don't believe it is possible to do it retrospectively - not through an automation. One option, depending on how many rows you have is to manually populate the Closed Date based on the date that Checkbox was set by viewing the cell history of the checkbox column for each row.
Select the cell and right-click, then choose 'View Cell history' from the menu and you get this:
You can then manually populate the date from the details here.
Thanks,
-
Happy to help!
My method could be modified to store multiple values in different columns.
Would that work?
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you!
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 349 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!