Conditional Formating

Thomas J Ehid

Thomas J Ehid ✭✭

07/23/20 in Formulas and Functions

I'm trying to setup a conditional format that when column A is greating than column B either a red flag / Red circle will pop up in a seperate column.

Thanks in advanced!

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

07/23/20

Are you using a flag type column?
=IF([Column A]@row > [Column B]@row, 1)

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
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!