I am trying to count the number of dates that are greater than or equal to todays date with this for

Options

=COUNTIFS([Expiry(3 years)]1:[Expiry(3 years)]12),<>,>=TODAY())

The sheet comes back with "unparseable"

Answers

  • Phil Wightman
    Phil Wightman ✭✭✭✭✭✭
    Options

    Hi @Tonyed

    Could you use a report to solve this? You could filer the report on the above criteria and use the summarise function to count the rows returned.

    Did this solve the issue Yes/No?

    Rgs

    Phil

  • Tonyed
    Tonyed ✭✭
    Options

    Thanks for your reply Phil, but the field is an active field in the spreadsheet that needs to updated automatically and this a formula worked in Excel but has some syntax problem in Smartsheet that I can't see at this point.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!