TRYING TO COUNT MULTIPLE DATA IN A COLUMN

Brandon Kennedy

Brandon Kennedy ✭

07/18/24 in Smartsheet Basics

Screenshot 2024-07-18 at 9.51.19 AM.png

looking to count all the data from 4P100,4P200,4P500 etc in one row

the deal I have is 0-500

501-1000

1001-1500

I am not wiz at this but I am trying to learn

Tags:

Formulas

0 ·

Answers

heyjay ✭✭✭✭✭

07/18/24 edited 07/18/24
=COUNTIFS( [Column Name]:[Column Name], CONTAINS("4P1", @cell))
Use the function CONTAINS is searching for partial match.
...
0 · Share on Facebook Share on Twitter
Brandon Kennedy ✭

07/18/24

I will try that thank you

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…

Help shape the future of Smartsheet.
Share your ideas and feature requests.