Auto-populate Cell after trigger
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
Check out the Formula Handbook template!