Help needed with formula calculating open issues based on status, owner and due date

Options

The formula is not pulling all data. Below are the formulas I am using:

Overdue: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <TODAY(0))

Due in 1 month: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <=TODAY(30), {Current Completion Date}, >=TODAY(0))

Due in 3 months: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <=TODAY(90), {Current Completion Date}, >TODAY(30))

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!