Determining Open Issues based on a date

Hi Community. I need to develop 2 formulas based on STATUS and LOG DATE

  1. Need to total request status that may be "In Progress", "Retest", "New", "Pending Closure", etc. (there is a laundry list) that have been opened based on a date. The starting date is 5/15. I need to see this total daily.
  2. Need to total requests where the status is "Closed" based on a date. The starting date is 5/15.

I will run the formula daily, so on 5/15 it will give me a total for each day. On 5/16 I'll run it again. I have to do this for 6 days so it won't be too bad. So maybe the Today() function will work?

Thank you for your assistance.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!