IF function with column formulas

Dan Pollino

Dan Pollino ✭✭✭

10/12/22 in Formulas and Functions

Good morning,

Is there any way to change the syntax on this formula so that it can be made into a column formula?

Thanks!

0 ·

Answers

Michael Culley ✭✭✭✭✭

10/12/22

change the [equivalent trade]1 to [equivalent trade]@row

0 · Share on Facebook Share on Twitter
Dan Pollino ✭✭✭

10/12/22

Thanks so much and sorry for the newb questions.

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

Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!
Need a formula for % complete for all phases on the parent project summary row. Row is non editable
I need an average formula in the parent project summary (row 23). Formula should include all phases (initiating, planning, executing, closing). The parent row is un-editable and not allowing me to enter a formula.