Formula Formatting Question


Please forgive the newbie question but I am trying to get a count of services performed across columns from two sheets with a specific criteria:

  1. Current Tracker
  2. Tracker Archive

The formula I am using returns INCORRECT ARGUMENT SET

COUNTIFS({Request Tracker Range 1}, "Edit Seat", {Request Tracker Archive Range 2}, "Edit Seat")

I am sure that I am not bracketing the argument correctly but all my attempts at variation return the same error.

Any hints are appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!