RYG Balls connected to Whether Items are completed or not.

I am looking to connected RYG balls to whether certain items are complete or not?

I am not sure of the best way to do this- if a checkbox would be the way to connect color change based on status of task, or if inputting a "completion date" would do the same thing?

I tried a couple of different formulas from these forums and I can't seem to figure it out.

Find more posts tagged with

Healthcare

Formulas

Project Management

Comments

Mike Wilday

You can use a nested IF statement to change the color based on your status.

You would create the symbol column and put this formula in it... and adjust the row number to represent the correct row. The following formula will look at row 23 of a column called Status and turn it Red if its' blank or Not Started, Yellow if the status is set to In Progress, and Green if Complete. You can change the status requirements by adjusting it to match your status'. If your column names include spaces, put the column name in brackets like this... [Project Status]23

=IF(OR(Status23 = "Not Started", Isblank(Status23)), "Red", IF(status23 = "In Progress", "Yellow", IF(Status23 = "Complete", "Green")))

Sign in to join the conversation!

Quick Links

Trending discussions

Set contents of two columns into 1
Hi - trying to figure out a formula that combines two columns into one long column, maintaining contents in multiple rows. Noting that the number of items in each column will change as these are each using the index/distinct to summarize a separate sheet. For example: Thanks for any help!
Unparsable formula; Sheet summary SUMIF formula
Can anyone help why this formula is coming up as unparseable? I'm creating a sheet summary, where it totals the Estimated GP (Est. GP) column if the Status column has the "Quoted" drop-down option is selected. Formula i've used: =SUMIF(Status:Status,"Quoted",Est. GP:Est. GP) Thanks a lot!
INDEX/MATCH Most Recent Entry
I am trying to pull from a sheet that is essentially a list of new records that are entered weekly. To keep things clean I have a helper sheet that just lists the project name once and the rest of the columns pull in through an INDEX/MATCH. I am trying to have that helper sheet pull in only the most recent entry. There is…