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))))

Find more posts tagged with

Accepted answers

Paul Newcome

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.

All comments

Melissa Yamada

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:

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

MichelleL

I clicked the cell and convert to column stays grey so you can't select it.

Andrée Starå

https://community.smartsheet.com/discussion/comment/465934#Comment_465934

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!

MichelleL

column type is duration

Andrée Starå

https://community.smartsheet.com/discussion/comment/465953#Comment_465953

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!

MichelleL

No, sorry can you explain that more?

MichelleL

I figured out that I am using a dependency. So is there another way to get the same info?

Paul Newcome

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.

Andrée Starå

https://community.smartsheet.com/discussion/comment/465982#Comment_465982

Unfortunately, there isn't, not without using a 3rd-party solution or the Smartsheet API or add-on, Bridge.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.