Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Counting party size from Symbols
gtucci39281
✭✭
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
Tags:
Comments
-
This will require additional columns. There are a number of ways to do this. This was the fastest way I could think of. You Will need to create 2 columns and perform a vlookup. See attachment.
Also I would lock the additional columns, so they are not overwritten.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am trying to create a formula that looks at 2 different columns Term Ending Date and Amendment - Ending Date. If column Amendment Date does NOT contain N/A it should return the value in [Amendment -…
- Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up …
- Hello, I've formula use Workday to count Due date = Start Date @row cell + option days. fx Image below: Start Date is 04/24/25, then added 11 days = Resulted 05/09/25 as Due date. Now, out of curiosit…