Unable to Convert to Column Formula

JK_packgene

JK_packgene ✭

5:50PM 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 ✭

6:28PM 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 ✭

6:28PM 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

Unable to Convert to Column Formula
Using this formula Smartsheet isn't letting me convert to a column formula: =[Material Received]@row - [Purchase Date]@row - [Lead Time (days)]@row
Multiple IF statements
Hello, I'm trying to make an IF( formula for the following criteria. If Tech is YES and Curved is YES, 650 If Tech is YES and Curved is NO, 500 If Tech is NO, 0 Thank you!
Sum amounts within certain year and type
Hi, I have a report listing payment (i) amounts for various (ii) items and the (iii) payment date in long date format. I am trying to sum all the amounts per year and per item. Example: SUMIFS(amount, type = "paint", year = "2023") Adding up all the values in "amount" column if the type column is "paint" and the "date"…