Dependencies choking date formulas

Tina Rustvold

Is there any work around to keep date dependencies and still run calculations using those columns? Before dependencies were enabled my formulas worked fine to support my dashboard. Do we need additional helper columns?

=COUNTIFS({IMPACT}, Metric@row, {END} >=(2021, 10, 1), {END} <=(2021, 12,31), {STAT}, "In process")

Paul Newcome

Try using the DATE function. You are also missing a couple of commas.

=COUNTIFS({IMPACT}, Metric@row, {END}, >=DATE(2021, 10, 1), {END}, <=DATE(2021, 12,31), {STAT}, "In process")

Tina Rustvold

Oh goodness--time to update the glasses. Thank you!

Paul Newcome

Happy to help. 👍️