Countif Query

grant53396 ✭✭
edited 12/09/19 in Formulas and Functions


I currently have the following formula which is used for counting how many jobs we intend to complete on a day:

=COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY())

This works fine, although there is a scenario where we often add things to the job, which is identified by a letter A in the job number. I need a formula that counts how many will complete except the ones that have an A in the job number...

I was thinking of something like =IF("job number contains "A"", "",COUNTIF({Realistic Completion Date 4}, {Realistic Completion Date 4} = TODAY())) But i am not sure how to do the first bit of the formula... can anyone help?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!