Formula issue

Finops C'ship

Can someone help me to write these five formula in a single formula to get the schedule health.

IF(Status@row = "Not Started", "Gray")

IF(Status@row = "On Hold", "Yellow")

IF(Status@row = "Not Applicable", "")

IF(Act1@row >Act2@row , "Red")

IF(Act1@row <Act2@row , "Green")

THanks

Find more posts tagged with

Sheets

Formulas

Reports

Project Management

Accepted answers

All comments

TVang

Hi, @Finops C'ship.

Give this a try...

=IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On Hold", "Yellow", "")), IF(Act1@row > Act2@row , "Red", "Green"))

Finops C'ship

Hi @Toufong Vang

Its not working...we have 4 colors symbols

if the status is set as Not applicable it should be "" i mean without any color..can you help

TVang

Hi, @Finops C'ship ,

Thanks for the feedback. I see the error in the formula...

Try this...

=IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On Hold", "Yellow", IF(Act1@row > Act2@row , "Red", "Green"))), "")

Here is the formula formatted so that it's a little easier to read

=IF( Status@row <> "Not Applicable"
	, IF( Status@row = "Not Started"
		, "Gray"
		, IF(Status@row = "On Hold"
			, "Yellow"
			, IF(Act1@row > Act2@row 
				, "Red"
				, "Green"
				)
			)
		)
	, ""
	)

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.