CountIf Status Last 30 Days & Next 90 Days

Hello,

I have a sheet that has a columns that include Status, Start Date & Finish Date.

I need a countif formula that will pull back how many Completed (Status) have fallen within the last 30 days (Finish Date).

I need a countif formula that will pull back how many Not Started (Status) will fall within the next the 90 days (Start Date).

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!