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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…