Can't Covert to Column Formula
I am trying to convert some formulas to column formulas, but the feature is greyed out and will not let me. Is this because of the way it is written, or the type of formula being used?
Two specific scenarios are as follows:
- Target Duration - formula is: =IF([Project Type]@row = "Quote", 10, IF([Project Type]@row = "Profile", 5, IF([Project Type]@row = "Schedule", 5, IF([Project Type]@row = "Special Project", 15, "False"))))
- Actual Duration: =IF(ISBLANK([Actual End Date]@row), "TBD", (NETDAYS([Start Date]@row, [Actual End Date]@row)))
…The other formulas I was able to make column formulas as indicated by the icon.
Answers
-
Create a new column and try it. If that does not work, create a new sheet and try it. I can create column formulas with your formulas.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!