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

Formula to check a box when specific criteria are met
Hi! I am looking for a formula to check a box when specific criteria are met. I have multiple columns that have dropdown options. I would like the box to check when each of those columns have either "Approved" or "Declined" selected. But if "Submitted" is the option shown, then it should not check the box. So all…
Formula to populate field from another sheet using multiple criteria
Hi there, In one sheet ("pay scale") I have our employee pay scale and in another ("Employee Salary") I have our employees listed with their experience and education levels. Is there a Smartsheet formula that I can use to pull in their salary based on their experience and education levels? For example, if they have a BA +…
Forumla Help: IF Statement with Vlookup Across Sheets
I have created two resourcing documents (pictures below for a visual) Resourcing Sheet - This is the sheet where we resource each project by person Resourcing Rollup- The sheet is rollup to show how many hours the are allocated each week by person and gives a rollup of hours What I am trying to do: Look up (example name)…