Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Tracking overall attendance to event
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.
Comments
-
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
-
Appreciate your help Pam,
You knocked out our problem with ease.
Thanks.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives