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 Community Champion

07/23/20

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

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
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

Help with writing a formula to show Completed and Past Due along with other status.
Hi there, I am able to get all the status to show correctly, except the 'Complete' and 'Past Due', I know its something simple and I am just not thinking of it, help is appreciated! I am using a 'End Date' and '% Complete' Formula used on the 3rd date down =IF(OR([% Complete]@row = 0, ISBLANK([% Complete]@row)), "Not…
FORMULATE FOR DAYS
I want a formula that will capture network days between dates but that will count only if cell has a date entered. DEPT DATE-1 DEPT DATE-2 RETURN DATE TOTAL TRAVEL DAYS 5/10/2025 5/20/2025 5/30/2025 7 5/10/2025 5/30/2025 The formula should into the TOTAL TRAVEL DAYS Column and will count days based on following scenarios:…
Sumif, index/match and iferror help
I am attempting a formula to sum specific cells from a column from a reference sheet if the Shift column from the origin sheet = 1st and the dates match on both sheets and a return result of 0 if there is not a match, but I'm not getting the arguments correct. #INCORRECT ARGUMENT SET I've tried this as well. #UNPARSEABLE…