How to combine formulas?

Hi all, I am trying to do some simple calculations for a project dashboard, e.g. showing the number of actions that are "not started", "in progress" (or those that are not complete or not cancelled) and that are also overdue, i.e. less than today's date. I managed to calculate the number of open actions, I also managed to calculate all actions that were due before today. But how do I combine a formula to get BOTH in one calculation?

I tried the formula below but that gives me an unparseable error.

=COUNTIFS({Actions Log Status}, <>"Complete", {Actions Log Status}, <>"Cancelled") AND (COUNTIF({Actions Log Due Date}, {Actions Log Due Date} < TODAY(0))

Any advice would be appreciated.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!