COUNTIF/S Sheet 2 has "Auto Doors" in dropdown


New to Smartsheet and trying to get a ticketing system going for our FY 2024. I've done a Form already and am working on a metrics sheet for a Dashboard. This is all VERY new to me and I've had no training but I got a subscription and trying to make the best of it.

I have Sheet 1 where the Form responses go to. I have Sheet 2 where I am trying to tally all my information. I am trying to count the amount of times each program is requesting a new ticket but I can't seem to get it right. Thank you!!

Best Answer

  • Victoria_Indimar
    Victoria_Indimar ✭✭✭✭✭
    Answer ✓

    Hello and welcome!

    If your Program list in Sheet 2 is written out to match the option in your form and entries in Sheet 2, then you can just reference those for look up:

    =COUNTIF({Task Request Range 1},=Program@row)

    Where "Program" is the actual column header you have the list Auto Doors, Baler, Compactors, etc.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!