We’re planning a large meeting. We’ll be using Smartsheet for registrations via a form. There are about 80 guests we want to make sure register. I have attached screenshots. Sheet A is the guest list. Sheet B will be collecting the registrations.
Is there a way to set up a cross-sheet formula that marks off each person on the guest list when they register using the last name? On the guest list (Sheet A), I have a column called “Registered.” I’d like to see a checkbox, a green symbol, or the word “yes” if someone registers with the last name in that row.
I struggle with formulas. Is there a way to do this?
