Convert week numbers back to physical dates
vipa2000
✭✭✭✭
Hi, I am new to smatsheet. I have transferred an excel file into smartsheet. After some use I have decided I don't want to use week numbers, but dates so I can leverage the power of smartsheeet. I found the following code =DATE(2019, 1, 1) + 7 * ([Task Start]1 - 1)
It was originally for 2018 so i simply change the 2018 to 2019. I get a constant error - Invalid column value. I thought it was because the 'task start' had a space but no. Any ideas please? Regards Paul
Comments
-
Make sure the column you are putting the formula is in is set to be a Date type column.
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!