How to formulate below?

Hi team,

to get someone help me with my issue as i can't seem to get the formula working if i wanted to count the current status with date ranges? I have read and tried all exmaples but my formula seems to be wrong all the time.

As you could see i wanted to count these current status based on on the issuing date. i have added alot of dates to find the correct way to formulate but i have a dead end every time.

Thanks to help me out.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!