Convert to Colum Formula on new duration column


Playing around with the new duration column on calculating days between two dates. I am unable to convert to column formula. I can see that you need absolute reference which I believe I had. Hoping someone could point me in the right direction, please and thank you.

If I use this formula I get the right answer =([End Date]@row - [Start Date])+1 but then can't convert.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!