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")
Tags:
Answers
-
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")
-
Oh goodness--time to update the glasses. Thank you!
-
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!