Sheet Summary Question
Hello all, I am trying to do a sheet summary to show the Active Dealers vs Non Active Dealers that are running campaigns. An active dealer will have a monthly total greater than 0. However the Monthly Total Column in the smartsheet is a referencing information from another smartsheet using a Vlookup. I am trying to do a CountIF to count the amount of active dealers based off their monthly total being greater than zero however the formula is showing #NO MATCH and I think this is because of the cell reference / vlookup formula. I tried making a seperate column with a formula IF([Monthly Total]@row greater than 0, "Active", "Not Active" and do a Count If off of that column however I am still getting the #NO MATCH error.
Help Article Resources
Check out the Formula Handbook template!