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?
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.
I am trying to populate a column from Sheet A into Sheet B and Sheet C. My Lookup column for Sheet A is formatted as such so there is a ' in front to account for ones that have a leading 0 and some do not. Each ID should be 6 digits long. I made a helper column looking at this Dealer ID column to try and get rid of that…
am I able to separate this into multiple rows? in a new sheet? Desired Result -
I would like to parse out this data by creating a listing with a row for each person, for each project they appear on, for each month. I think this would only give me the groupings anyways, but this doesnt seem to even get me started - it popped up then people have disappeared.