how do i get a smartsheet to automatically register completion date in a cell based on condition to be achieved in another cell?
for example, a task to automatically register the completion date on the day a task is approved by a manager
Hi @matthew chan
Unfortunately, it's not possible at the moment to lock the date, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
As a possible workaround, you could use,
Would any of those options work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Andree's solution about copying a row to a sheet would indeed give you a hard date that you could use vlookup with a cross-sheet reference to return the date it was moved. You'd need a new sheet with a system column for date created. Then you could vlookup for that task name in your time sheet and return the time created field.
For more on copying rows see:
For more on Cross sheet refrerences see:
For more on Vlookup see:
Thanks Andree and Mark for your advise. I'm new to smartsheet. Just trying to figure out what is possible and what's not.
You're more than welcome!
Have a look here at my post on how to do it without Zapier.
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Please let us know if you get stuck along the way or come up with new questions. Have a good day.