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

Find more posts tagged with

Formulas

functionality

Automations

Conditional Formatting

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.