How to if statement for more than one cell ?
What I have is three cells with dates and I want the sheet to check if there is a date in the 3rd cell to count from that date if not to check the second and if not to check the first cell
Try something like this...
=IF(ISDATE([3rd Column]@row), [3rd Column]@row, IF(ISDATE([2nd Column]@row), [2nd Column]@row, IF(ISDATE([1st Column]@row), [1st Column]@row))) + n
Just replace n with however far out you want to go.
Dear Paul ,
Thank you for your reply,
I got an error message (#INVALID COLUMN VALUE)
The formula above would need to go into a date type column.
It is all date type column
Are you able to provide a screenshot of the columns and the formula generating the error?
And can you provide a screenshot of the column properties for the column that the formula is in?
That's for Date 2 which is referenced in the formula. What about the column the formula is actually in?
I got you
Now It is working perfectly
Thank you Paul
Great! Happy to help. 👍️
©2022. All Rights Reserved Smartsheet Inc.