Date Formula

Folkes

Hello is there a function where a date can be calculated based off a selection from a drop down in another column. For example, if someone selected a status saying "In approvals" which takes 5 days to complete can Smartsheet calculate 5 days from today's date and display that date in another column?

Isis Taylor

@Folkes I'm glad that worked. See below to include different statuses.

=IF([Status]@row = "In approvals", TODAY() + 5, IF([Status]@row = "Authorizing", TODAY() + 7, IF([Status]@row = "Testing", TODAY() + 10)))

Isis Taylor

@Folkes Try this.

=IF(Status@row = "In approvals", [Status Date]@row + 5, "")

You could also try this.

IF(Status@row = "In approvals", TODAY() + 5, "")

Folkes

@Isis Taylor It worked! Thank you so much. I do have another question; how do I write the formula if there is more than 1 selection from the drop down. For example, "In approvals", "Authoring", "Testing". Each one has a different time it would take to complete.

Isis Taylor

@Folkes I'm glad that worked. See below to include different statuses.

=IF([Status]@row = "In approvals", TODAY() + 5, IF([Status]@row = "Authorizing", TODAY() + 7, IF([Status]@row = "Testing", TODAY() + 10)))

Folkes

@Isis Taylor you're amazing! Thank you.