Formula's Broken
Team,
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.
Answers
-
If you are referencing another sheet using "Renewal Victories V2!Agent" this should be in '{ } brackets,' for example, {Renewal Victories V2!Agent}. When writing the formula I suggest using the button that says reference another sheet because it will format it correctly for you.
-
=COUNTIFS(Renewals!Agent, "Name 1", Renewals![Platform - OE], "<>")
Modified to
=COUNTIFS("Renewals"!Agent, "Name 1", Renewals![Platform - OE], "<>")
Still does not work. Can't seem to get past this.
Essentially I am saying:
Check the sheet labelled "Renewals"
Match agent name to: Name 1
Count renewals that have column "Platform" as OE"
Then count renewals that have column "platform" as as BSG.
Driving me insane! lol
-
This article should help you get started with some of the syntax differences between Excel and Smartsheet.
Help Article Resources
Categories
Check out the Formula Handbook template!