Auto-date function based on dropdown menu


Looking for some help in getting automatic dates to populate based on a status update dropdown menu.

I'm working on a smartsheet that tracks quote requests. Right now I have a status drop down menu that triggers automation. I also have dates in separate columns that track when the request was sent to a vendor, when a request was received from a vendor and when a request was sent back to our internal customer.

I tried to set up automatic dates based on those status updates - however since all three date columns are linked to the same status update column, they change as the status update changes. Is there a way to keep those dates once it gets populated, regardless of if the status changes after that? The way I have tried it works in populating the dates, however every time the status criteria changes, the dates disappear from the previous column when the new one updates.

Please see below for reference if my explanation isn't good enough.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!