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.

Jeana

Best Answer

Answers

  • Jeana
    Jeana ✭✭✭✭✭✭

    Thanks Genevieve,

    This certainly works when I'm just looking for a date in the cell. I was not aware of the ISDATE funtion.

    Thanks!

    Jeana

  • Great! Glad this will work for you :)

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!