Convert week numbers back to physical dates

vipa2000
vipa2000 ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!