1

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.