COUNTIFS formula question combining date condition and text condition


Why does the first formula fail when it is a combination of the bottom 2? The column is a Text/Number column

Asia formula: =COUNTIFS({CSA UK Surveillance Region}, =[Primary Column]@row, {CSA UK Surveillance Db. Expiry Date}, <TODAY(+90))

Europe formula: =COUNTIFS({CSA UK Surveillance Db. Expiry Date}, <TODAY(+90))

North America formula: =COUNTIFS({CSA UK Surveillance Region}, =[Primary Column]@row)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!