Capacity vs Demand Utilisation RAG Column

Hello,

I'm looking to create a capacity vs demand utilisation RAG Column where it will appear with Red, Amber, Green for the following rules:

Green: Total Q1 Capacity = Q1 Total Demand

Yellow: Total Q1 Capacity > Q1 Total Demand

Red: Q1Total Capacity < Q1 Total Demand

Kind Regards,

Luke

Find more posts tagged with

Formulas

functionality

Automations

IT & Operations

Accepted answers

All comments

Scott Peters

Hello Lukas - I think a nested IF formula would work here. Set the column properties to be symbols (R,Y,G), and then set up a formula something like if([Total Q1 Capacity]=[Q1 Total Demand], "G", if([Total Q1 Capacity]>[Q1 Total Demand], "Y", if([Total Q1 Capacity]<[Q1 Total Demand], "R")))

By having your formula results be the 3 letters R, Y, or G, Smartsheet will apply the correct symbol

Hope this helps,

Scott

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.