Formula to show Status based on several fields that may or may not have a date entered.
Hi, first let me say that Smartsheet formula's are fairly new to me so if I'm approaching this all wrong please tell me and I'd appreciate any suggestions.
I'm trying to establish a formula for a Text field that will automatically populate with the appropriate status based on whether several other fields have a date in them or not.
Here's the fields I'm working with:
Current status - this will have the formula
Uploaded - if date entered Current status should display "Uploaded to Vimeo"
Captions and transcripts requested - if date entered Current status should display "Captions and transcripts requested"
Captions and transcripts to Copyeditor - if date entered Current status should display "To Copyediting"
Captions and transcripts Complete - if date entered Current status should display "Captions and transcripts complete"
Final links sent to requester - if date entered status should read "Job Completed"
Thank you in advance for any help you can offer.
Help Article Resources
Check out the Formula Handbook template!