Trending in Formulas and Functions
-
Formula needed to count occurrence of a field value across multiple sheets
Scenario: Sheet A contains a field : Value Proposition. There are 8 rows in Sheet A. VP1 VP2 VP3 etc Sheet B and Sheet C have long lists of tasks, each task is assigned a Value Proposition (in field Value Proposition) In Sheet D (which is a Metrics Sheet) I need a formula to count the number of times that a Value…
-
I'm receiving an unparseable error with this formula? What do I need to adjust here?
=IF({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "3. Moving Along", "Green", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "2. Needs Monitoring", "Orange", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "1. Needs…
-
SUMIFS with sheet reference
I've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.