Trending in Formulas and Functions
-
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.
-
Help with COUNTIFS
So I am trying to make a metric sheet that uses a COUNTIFS sorting by month, year, lane, and to only count if approve is check. I will make a dashboard that eventually sorts by the lanes (3 of them in total) and it will be tracked for trends in change in months and years. Below is the sheet that is connected to a form…
-
Formula to flag overdue tasks
I've got a formula that flags overdue tasks, but it flags every task with no date. Is there a way to omit nulls? =IF(Status@row <> "Complete", IF(Finish@row > TODAY(), 0, 1))