If formula return date
I'm trying to make a check on a cell and once it goes to a particular value "Committed" I want create a time stamp of the current date in another cell on that same row. Seems simple enough, except for me :). Here is what I tried to put in place:
=IF([Stage]="Committed", DATEONLY(), )
Maybe I don't understand the DATEONLY formula....
Thanks for help!
Answers
-
Hey @Dennis Ruff
There is automation on the sheet that will do exactly what you want to do.
Above your sheet menu is AUTOMATION. Go into that. You can use CREATE WORKFLOW FROM TEMPLATE. When the page opens, scroll down to the blue section. Choose record the date when specified criteria are met
Once there, click Use Template
then #1 Title your workflow.
#2 Choose your Status column (however you have it named), then #3 select COMMITTED as the value
#4 Choose the appropriate Date column (Note that in the example below I chose my column 'Finish'. This is just an example). Note this column MUST be formatted as a date column to appear in the list.
That's it!
Kelly
-
Thank you Kelly!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 433 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 505 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!