=WORKDAY formula not calculating
I am trying to calculate a date that is 30 days after an existing date field in my sheet, "Travel End date".
=WORKDAY([Travel End date], +30)
I've tried making formula specific to row by adding 1, and tried adding @row, and still get "unparseable message.
Thanks,
Tanya
Answers
-
Try using an @row reference and removing the +
=WORKDAY([Travel End date]@row, 30)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!