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), "-")
Help Article Resources
Check out the Formula Handbook template!