Welcome!

Date Formula with Specific Criteria

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

Find more posts tagged with

Comments

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".

Sign in to join the conversation!

Quick Links

Trending discussions

Week Number Year to Year
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
Issues with IF formula
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…