Auto-populate Cell after trigger


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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!