Trying to use TODAY function

Sean Maney

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

Eric Law

Hello @Sean Maney

Please edit your formula to

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

Sean Maney

Didn't work...?

Sean Maney

=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?

Eric Law

Can you screenshot what you see?

Mike TV

@Sean Maney

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.

Sean Maney

#unparseable

Sean Maney

they are not drop downs

Mike TV

@Sean Maney

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