Date Formula with Specific Criteria

Anthony Barthelemy

Good evening Smartsheet Community:

I trying to create a formula that would give me the Number of Done in the Status Column based on Today's Date so I can see at any given time how many issues are done. If anyone has a similar formula they can share that would be awesome.

Thanks

Anthony Barthelemy

Smartsheet Community I think I figured it out. This formula will count the Number Deployments for the Current Week (M-F), unless a resources does deployment on the weekend

=COUNTIFS(Status:Status, OR(@cell = "Done", ISBLANK(@cell)), [Deployment Date]:[Deployment Date], AND(@cell >= TODAY(-5), @cell >= TODAY()))

I will test this out for the upcoming week and let everyone know my results on Friday

Anthony Barthelemy

Spoke too Soon. Back to the drawing board. If anyone has this formula,,can you please posted it?

Paul Newcome

What is your exact criteria? You said in your original post that you wanted it based on today's date, but in the formula example you provided, you referred to "current week".