Display actual date among 3 date columns (forecast, planned and Actual dates)

Shankar yellamraju · 06/27/24

I have 3 columns in Smartsheet. They are forecast date, planned date and actual date. I need a new column such that the condition should be if only forecast date is present display that. If both forecast and planned date are present, display planned date. If all 3 dates are present, display actual date. I tried to use this formula below but id didn't work. Please help.

=IF(ISDATE([Actual Date]@row), [Actual Date]@row, IF(ISDATE([Planned Date]@row), [Planned Date]@row, IF(ISDATE([Forecast Date]@row), [Forecast Date]@row, "")))

Paul Newcome · 06/27/24

When you say it "didn't work", are you getting an error message or an unexpected output?

Shankar yellamraju · 06/28/24

Error message

Paul Newcome · 06/28/24

And what is the error message you are receiving?

Shankar yellamraju · 06/28/24

incorrect argument

Shankar yellamraju · 06/28/24

Paul Newcome · 06/28/24

That is not the same formula that you have listed in your original post. Have you tried the formula in your original post?

Display actual date among 3 date columns (forecast, planned and Actual dates)

Answers

Categories