Help with a date formula.


I would like to enter in a date into the end date column (its currently enabled as a date column) however the formula listed below returns an error of #DATE EXPECTED. The false value "-" shows up but the date does not. Any help on this would be greatly appreciated.

Here is my logic written out.

if rotation # column = 1 then enter the date 05/08/2021 into end date column. Im missing something but I cannot see it.

=IF([Rotation #]@row = "1", [End Date]@row = DATE(2022, 5, 8), "-")


Best Answer

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    edited 03/06/21 Answer ✓

    Oh wait, I didn't even notice the row reference-you wouldn't need the [End Date]@row reference- it would only be the date as the true statement.

    =IF([Rotation #]@row = 1, DATE(2022, 5, 8), "-")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!