Trending in Formulas and Functions
-
Can someone tell me what I am doing wrong in this formula to set the status ball color?
=IF([Estimated or Actual Finish]@row>Finish@row), "Yellow", IF(AND([% Complete] < 1, Finish@row < TODAY()), "Red", "Green")
-
Help on NOT function within COUNTIF(S)!
Hi all, I am trying to create a formula for a sheet summary. I have a "Chem" column that is populated from a form, and could be any one of 26 chem types. I want my summary to return the total number of chems within the Chem column, but I don't want it to include a specific chem, WOS, AND I don't want it to count blank…
-
Count Formula Help
I need a formula that will count the # of times a task is in a specific status. The goal: Formula can tell me 6 tasks are in In Progress. Example (see screenshots). Project Plan - Observe AI: Status column 2. Test Sheet: Would I use a countif formula? If so what would the rest look like to calculate?