Formula's Broken


Am new to Smartsheets and am trying to create metrics sheets that I can then create reports and dashboards from.

The formula I am using, for example is:

=COUNTIFS(Renewal Victories V2!Agent, "Name 1", Renewal Victories V2![Platform - BSG], "<>")

I can't figure out why none of my formulas will work.

I am trying to create a sheet that shows me, in this example

Count the number of Platform wins on 1 platform over another. Then the MRR then the Seats, etc.

Referencing a sheet titled Renewal Victories V2.

After I have metrics and dashboards done I want to use some pipeline automation and create a pipeline for the team.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!