Sign in to join the conversation:
For RYG indicators I am using the same formula for all rows in my sheet but as you can see from my screenshot some rows have different results. Dates are the same, status and % complete are the same. How is it possible to have different results?
IF statements stop at the 1st correct answer which is probably throwing off your results. I rearranged one of the conditions.. try this and see if its closer.
=IF(Status@row = "Complete", "Green", IF([Start Date]@row > TODAY(), "Gray", IF(AND([% Complete]@row <1, [End Date]@row < TODAY()), "Red", "Yellow")
I figured it out, they all referenced row 77 but 1 referenced row 76.
What I haven't understood is why my [square] brackets keep disappearing.
Try removing specific cell references by replacing with @row instead. It will speed up your sheets and makes your formulas more efficient.
[ ] brackets are only needed when a column name has a space in it. Otherwise, they aren't necessary and will fall off.
I have a report that is referencing a control center program. Other users that are setup as leads on the program and have the same admin permissions I do are able to edit the Group, Filter, Summarize and Sort settings of this report, but I can not. When I click the Columns button it just says "Loading" and even if I leave…
I wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…
I have 165 projects in the portfolio, each with 5 gates and ~120 steps in a project. As an example if a project has successfully passed gates 1&2 and is coming up on gate 3 review, I want to be able to see the rollup at the portfolio then "zoom in" to see the project plan details for a specific project and gate 3. With my…
