# Trying to use TODAY function

Options
✭✭✭✭

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

• ✭✭✭✭✭✭
Options

Hello @Sean Maney

=COUNTIFS([R Status]:[R Status], "R1 - Bid/No Bid", Stage:Stage, "Active - High Probability",[Bid Due Date]:[Bid Due Date], < TODAY ()) and it should work.

• ✭✭✭✭
Options

Didn't work...?

• ✭✭✭✭
Options

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

Any other ideas?

• ✭✭✭✭✭✭
Options

Can you screenshot what you see?

• ✭✭✭✭✭✭
Options

What error are you getting with the updated formula?

Are either the "R1 - Bid/No Bid" or "Active - High Probability" in multi-select dropdown columns? If so, you'll have to use CONTAINS to confirm if the cell contains those as part of multiple choices selected.

• ✭✭✭✭
Options

#unparseable

• ✭✭✭✭
Options

they are not drop downs

• ✭✭✭✭✭✭
Options

Is the Bid Due Date a date which is generated by a formula? If so, maybe SmartSheet doesn't think it's a date? Try this somewhere:

=IF(ISDATE([Bid Due Date]1), "Is a date", "Not a date")

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!