Does anyone have a great guest list tracker tempate. I have been working on one but i am having difficulty figuring out the formula for a specific colum. TIA
laural2979
Posted:
Member since
Re: Guest List Format
What kind of formula are you trying to do?
sugar4spc
Posted:
Member since
Re: Guest List Format
I want it to add up all my total for Rsvp Yes and RSVP no
libby2595
Posted:
Member since
Re: Guest List Format
you mean like in excel??
laural2979
Posted:
Member since
Re: Guest List Format
What I did was just add an extra column for invites. Since not everyone on the list would receive one, I put a 1 next to the primary name in the family. Then just highlight that whole column and select the sumation button. This will give you your total number of invites.
ali120206
Posted:
Member since
Re: Guest List Format
I put three columns in, a yes, a no and a not responded and then summed them up. When we put a number in the yes or no column, the formula in the not responded changed that number to 0.
libby2595
Posted:
Member since
Re: Guest List Format
Posted by ali120206
I put three columns in, a yes, a no and a not responded and then summed them up. When we put a number in the yes or no column, the formula in the not responded changed that number to 0.
that's what i did... worked great
qdavis
Posted:
Member since
Re: Guest List Format
Posted by sugar4spc
Does anyone have a great guest list tracker tempate. I have been working on one but i am having difficulty figuring out the formula for a specific colum. TIA
if you want i can email you a formatted guest list...just fm me ok
JXNOscar
Posted:
Member since
Re: Guest List Format
We tried all of those 'nifty' guest list trackers. We found just using excel worked best
