Calculated Field Problems
I'm trying to get a count to tell me if guests are coming to an event.
I have a field called RSVP Status and the choices are radio buttons for No, Yes, or Yes+1.
I have a calculated field that I've loaded with the following calculation that does not give me what I want.
I'm looking for it to put either 0, 1, or 2 in the field and I only get a 1 for no so I'm completely lost.
(Thursday Dinner RSVP="yes"; Thursday Dinner RSVP Count=1;If(Thursday Dinner RSVP="yes+1"; Thursday Dinner RSVP Count=2;If (Thursday Dinner RSVP="no"; Thursday Dinner RSVP Count=0)
Any help would be greatly appreciated.