Trending in Formulas and Functions
-
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))
-
Help with a Formula?
Hi, I am working on row of dates and I am trying to get the next due date (from today) in another column. I have tried a couple of formulas but get #UNPARSEABLE. What should the formula be? I am looking for the formula for the cell in yellow.
-
CountIF Formula with Criteria
I have a formula to count how many stores an owner has in our system. It is working great: =COUNTIF([Primary Contact (Company) (Company)]:[Primary Contact (Company) (Company)], [Primary Contact (Company) (Company)]@row) (You can see John Voskamp has 91 stores). I need to determine of the store count, how many are "Open".…