Formula's Broken

kbrown84

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.

Find more posts tagged with

Formulas

Accepted answers

All comments

Dakota Haeffner

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.

kbrown84

=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

Paul Newcome

This article should help you get started with some of the syntax differences between Excel and Smartsheet.

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.