Unable to Convert to Column Formula

JK_packgene

JK_packgene ✭✭

11/19/24 in Formulas and Functions

Using this formula Smartsheet isn't letting me convert to a column formula:

=[Material Received]@row - [Purchase Date]@row - [Lead Time (days)]@row

Tags:

0 ·

Best Answer

JK_packgene ✭✭

11/19/24 Answer ✓

Looks like when I changed the column format from Duration to Text/Number the formula could be applied to the column.

0 · Share on Facebook Share on Twitter

Answers

JK_packgene ✭✭

11/19/24 Answer ✓

Looks like when I changed the column format from Duration to Text/Number the formula could be applied to the column.

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Collect an column entry when data is entered by a form
Hi, I'm still tearing my hair out over this issue, and I'm hoping someone can help me. In our set up that is run through control centre, we have specific information that is entered onto a sheet via a form. I need to link the information that is entered into that form back to the metadata for each project. The issue I'm…
Schedule health formula to display blank symbol
Hello! I am curious how to edit the below formula, to show blank instead of green/yellow/red symbol if status/end date is blank: =IFERROR(IF(Status@row = "Complete", "Green", IF(Status@row = "N/A", "Green", IF([End Date]@row = TODAY(), "Yellow", IF([End Date]@row < TODAY(), "Red", "Green")))), " ")
Count HAS Function Between Dates
I have worked to find a solution out there but not getting one that works. I am collecting data from a sheet to be used in charts on a dashboard (so referencing another sheet). The result will need to be generated from two columns Date - date the project closed Fund - The fund/funds used to pay for the project (multiselect…