Counting party size from Symbols

gtucci39281
gtucci39281 ✭✭
edited 12/09/19 in Formulas and Functions

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? 

 

Party size.PNG

Comments

  • Marcus Odum
    Marcus Odum ✭✭✭✭
    edited 10/08/18

    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.

    2018-10-08 22_02_46-Smartsheet.png

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!