Convert to Colum Formula on new duration column
Hi!
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.
Answers

Hi K.J,
Please use @row after Start Date as follows:
=([End Date]@row  [Start Date]@row) + 1
Hope it will work.
Thank You !
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️

Thanks, @Anjanesh Vaidya. I had typed incorrectly above my apologies. That is the formula I already have working however the convert to formula option is greyed out.

I am guessing you enabled dependencies to get the Duration column and then disabled them in order to edit the column? I am able to replicate the same behavior so I suppose that is as intended. It is curious that the column retains the "special" formatting when disabling dependencies.

Thanks, Carson, you are right, and these are old columns from testing dependencies. Perhaps I'll test with a fresh sheet.

It doesn't appear that the duration column supports column formulas. @K.J It doesn't work no matter what I name the column or how basic the formula I put in is, the option to convert to a column formula is unavailable.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!