This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi Kimaike,If you wan to do this in a single table you'd need to use a script for this. However you can do the bulk of the work by splitting it into 3 tables like so:Edit: Just to clarify - you can get the Promoter/Detractor field using an IF stateme...
I've just rechecked the tables you've suggested in your jpeg and its definitely not the way to go. You'll end up with a table for both Bookings and Non Attendees. You just want 1 table (the attendances table) where you log bookings and if they turned...