Automated date due to change in dropdown list

Sebastian Roloff

Hi folks!

We're trying to set up a sheet where we are able to automated fill out different date columns due to a change within a dropdown column.

If entry of the status dropdown is changed to pending, the current date should be displayed in the Date Pending column and - important - being locked for any changes. So that if the status is changed again to another value (e.g. Start) the date in the Date Pending column stays the old one, but the current date is displayed in the Start Date column. I hope this was understandable 😣

First try formular was =IF(Status@row = "Pending"; TODAY(); "") For sure that does not work as it did not contain the requirement of lock the first date entered. The moment the status is changed to another value, the date in the Date Pending column is deleted.

Anyone any thoughts on this?

Thanks and best regards,

Sebastian

Andrée Starå

Hi @Sebastian Roloff

Please have a look at my post below with a method I developed that would work for your use-case it seems.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | 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!

Sebastian Roloff

https://community.smartsheet.com/discussion/comment/266945#Comment_266945

Hi Andrée

Thank you for your input. Unfortunately we're talking about a very big complicated sheet where we have many data involved and also many sub-sheets included (already with data mesh etc.). Therefore I think, that it is not possible for us to add another sub-sheet with additional meshs.