Tracking overall attendance to event

BryBrem

Building 2 different pages, one for general registration throughout the year, another to Track which companies have been to which events.

The Registration is coming easy but how do I get it to fill in the Tracking sheet/report?

So the Registration will track all the attendees for an event, of which there could be 1-10 people from 1 company.  But I want the other page to simply be a row for each company, and a column for each event and a checkbox for that column is clicked if someone from that company registered for the event. 

Is this possible to track automatically?  Thanks.

Pam Alakai

Hello,

We chatted about this today and I was able to help you set up some Count If formulas and cell links to create an automation between the two sheets. I sent you an email with instructions on how to set these up.

You can learn more about Count If formulas here: https://help.smartsheet.com/function/countif

You can learn more about cell linking here: https://help.smartsheet.com/articles/861579-cell-linking

Kind Regards 

Pam 

Smartsheet Support 

BryBrem

Appreciate your help Pam,

You knocked out our problem with ease.

Thanks.