Formula help with COUNTIFS


I know this must be a simple change but can't for the life of me figure it out! I'm just looking for End dates greater or equal to TODAY where the status is not "complete". This isn't working :-(

=COUNTIFS([Expected / Actual End Date]:[Expected / Actual End Date], >=TODAY, Status:Status,<>"Complete")

Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!