Column Formula
I wrote a formula but I can't select convert to column and I am not sure why any suggestions?
=IF(Shift@row = "Prime", [Hours Calculation]@row / 24, IF(Shift@row = "Single", [Hours Calculation]@row / 8, IF(Shift@row = "Double", [Hours Calculation]@row / 16, IF(Shift@row = "Stand-By", [Hours Calculation]@row / 1.42))))
Best Answer
-
The only way to update a dependency column automatically based on the results of a formula is through the API, the premium add-on Bridge, or some other similar third party app.
Answers
-
Hello @MichelleL
looked like your formula is correct. Make sure that you right click on the cell where you have the formula to be able to select the "Convert to Column Formula".
If this is not the case, do you encounter any error message?
You can check this article for reference on limitations as well:
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined -
I clicked the cell and convert to column stays grey so you can't select it.
-
Hi,
I hope you're well and safe!
In which column and what is the column type of the column you're trying to convert?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
column type is duration
-
Are you using the Dependencies feature? If yes, you can't use formulas in that column, which is probably why it doesn't work.
Make sense?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
No, sorry can you explain that more?
-
I figured out that I am using a dependency. So is there another way to get the same info?
-
The only way to update a dependency column automatically based on the results of a formula is through the API, the premium add-on Bridge, or some other similar third party app.
-
Unfortunately, there isn't, not without using a 3rd-party solution or the Smartsheet API or add-on, Bridge.
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Awesome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
