Trying to create COUNTIFS formula


I am trying to create a formula that will count occurrences of multiple things happening. Anytime a certain person (Name column) is found and anytime a date qualification (Date Qualification Completed column) was completed withing the last 90 days. I am using a data sheet as I want to use this output for a dashboard. Here is the formula i use: =COUNTIFS(Name column),"Carolyn",(Date Qualification Completed column),>=TODAY(-90) and it comes back #unparseeable or #invalid ref. Any ideas


  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    Is the formula in the same sheet as the data? If so, I believe this should work.

    =COUNTIFS([Name column]:[Name column],"Carolyn", [Date Qualification Completed column]:[Date Qualification Completed column], >= TODAY(-90))

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭

    Hi @Adam McCarthy,

    Your formula should look something like this:

    =COUNTIFS(Name:Name, "Carolyn", [Date Qualification Completed]:[Date Qualification Completed],

    Make sure that the Date Qualification Completed column's type is set to Date, as it won't work properly if it's set as Text/Number.

    Hope this helps - if you're still having issues then just post! 😊

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!