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
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!