Auto-populate Cell after trigger

kzulpo

Hi Everyone,

I am trying to auto-populate a cell with a date based on status "Sent to Client" (dropdown) being selected. I have this functionality already working with the formula: =(IF(Status@row = "Sent to Client", TODAY())).

How do I replicate this action for a different date cell based off of a different status? I want to KEEP the date that appears once "Sent to Client" is selected. I want a new date to populate in a separate cell after the new status is selected. Included a snip of what I am referring to.

RossL

Unfortunately that is not a capability out of the box. I would suggest submitting a product enhancement request here I know it has been requested to be able to add time stamp dates before but the more it is requested the better chance of it getting looked at.

https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?_ga=2.43240487.38431735.1594043554-1854870462.1583437315

kzulpo

Would an index reference work if I shot that date data to another sheet and then re-referenced it back to the original cell? Or you think I am I creating a loop at this point?

Andrée Starå

Hi @kzulpo

Have a look at the method I developed here.

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

Would that work?

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 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!