IF Formula

Lisa Welch

Lisa Welch ✭✭✭✭

12/05/23 in Formulas and Functions

How can I adjust this formula to return a "blank" if the value is $0?

=SUM([Actual Amount (finance use only)]@row - TOTALS@row)

Thank you,

0 ·

Best Answer

Nic Larsen ✭✭✭✭✭✭

12/05/23 Answer ✓

Try:
=IF([Actual Amount (finance use only)]@row - TOTALS@row = 0, "", [Actual Amount (finance use only)]@row - TOTALS@row

0 · Share on Facebook Share on Twitter

Answers

Nic Larsen ✭✭✭✭✭✭

12/05/23 Answer ✓

Try:
=IF([Actual Amount (finance use only)]@row - TOTALS@row = 0, "", [Actual Amount (finance use only)]@row - TOTALS@row

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

How can I make conditional formatting based on a positive or negative number?
I have "Budget," "Expenditure," and "Over/Under" columns. I already have a formula to calculate the "Over/Under" value. I want to have the value in that column show in RED font if it is over the "Budget" value (this will be different for each row). I tried in the conditional formatting section; however, the criteria only…
Add month in a date
Hello,I searched the forum but couldn't find any formula that worked. I'm trying to add a value (value defined in a column) to a date. I try the formula : =DATE(DAY([Contrôle effectué en]@row:[Prochain contrôle]@row); MONTH([Contrôle effectué en]@row:[Prochain contrôle]@row) + [Fréquence d'entretien]@row; YEAR(([Contrôle…
Formula to Automatically Update Red, Yellow or Green Symbols
I am having a difficult time getting the right formula for this. I would like to make it so if any of the dropdown options are selected that contain the word "Dead" then a red symbol auto populates in the column to the right. Any help would be greatly appreciated!