Multiple columns condtional furmola/formate

Waleed

Hi ,

I have fleet of cars

my drivers manually on daily basis type the KM/Millage reading in Column (Km/Today)

I need formulla for column Alert as follows:

• - - - - - - - - - - - - - - - - - - -- - - -

If number in col (Oil Next) is less than col ( Km/Tiday) the alert Col is (Green)

AND

If number in col (Oil Next) is Higher than col ( Km/Tiday) the alert Col is (Red)

• - - - - - - - - - - - - - - - - - - -- - - -

Also is it possible to have color change for cell (Km/Today) using conditional formating or automatiaion comparing two seperate column , without the need for helper column ?

Thank you for your assistance

Nick Korna

Hi @Waleed,

This formula should do what you're after for the alert column:

=IF([Km/Today]@row > [Oil Next]@row, "Red", "Green")

I'm not sure it is possible to have conditional formatting or automation in Smartsheet do the colour change for you without a helper column though (either the alert column, a check box or just a simple subtraction and comparing if positive/negative depending on how set you set it up).

Hope the formula helps though!

Waleed

Hi @Nick Korna

Many thanks , it worked perfectly for us

I hope to have automation / conditional formate to work also with multipe columns conditions