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

check box within date range
Hi community im looking for a formula to automatically check boxes related to dates from a table containing a start date and a end date table 1 is the dates source: table 2 (boxes to be checked) i'm trying this formula but there is no response: =IF(COUNTIFS({Sherbrooke - Time Off Tracker name}, [Main Tech]@row, {Sherbrooke…
Odd bug in Date formula?
So here is something I have been trying to tweek with no success…. I have this column formula which takes the date in column A and gives me the updated date of same month, last day + 2 yrs (ie 11/01/24 becomes 11/30/26) =DATE(YEAR([Appointment Month]@row) + 2, MONTH([Appointment Month]@row) + 1, 1) - 1 and it works great…
IF formula with multiple options
Good morning- Wondering if someone might be able to help me with this. I have a dropdown list column that has three options. If option A is selected, I want to automatically populate another column in the sheet with a specific message, but if option B is selected, I want to populate that same column but with a different…