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

Dollar amounts in a form
I am trying to require a form field to only populate a number to display in a dollar format. I can only see the requirement of a number, but not an actual dollar amount. Is this possible in a form?
Copied Smarsheet as new, now Conditional Formatting will not work at all
I copied a Smartsheet and changed some of the column headers. I deleted all the Conditional Formatting because it no longer applied. Then when I set up new Conditional Formatting, very simple - if this cell says YES, make the row green - it will not work at all.
Project Intake form in one workspace updated the Intake sheet in another workspace
Hope everyone is doing well. I would appreciate any insights you may have. I used the Project Management Template (PMO) to create an new workspace. Did this by saving this folder structure as NEW and called it MS Onboarding Lite. PMO structure: MS Onboarding Lite The first time I used the PMO to create a workspace was for…

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