Trying to use TODAY function


The first part of the formula below works, its only after I add ", TODAY () > [Bid Due Date]:[Bid Due Date]" that I get an error.

=COUNTIFS([R Status]:[R Status], "R1 - Bid/No Bid", Stage:Stage, "Active - High Probability", TODAY () > [Bid Due Date]:[Bid Due Date])

Any help is appreciated


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!