I am handling events in Smartsheet and need to include multiple invitees and speakers. However, I am facing difficulty in displaying the invitees and speakers based on the event ID.
Is there a way to achieve this in dynamic view?
Are you saying you would like the Dynamic View to be filterable by the event ID?
If that's not your question, please provide additional details for your request. A screenshot of your event sheet (with sensitive data blocked) with a description of what you want your users to see would be helpful.
Hi @Julie Fortney thank you for responding to my query.
I'm using three sheets for this use case - 1. Event details, 2. Speaker details(because of multiple line items), Invitees ( multiple line items)
1. Event details - All event information about the event like event topic,date venue etc.
2. Panellist details(because of multiple line items) - multiple panellist for an event and their info and payment info's
Invitees ( multiple line items) - Multiple invitees for example 20-30 invitees for an event.
I'm creating dynamic for the Initiator from Event details to show all the events created by the user. also I want to show the panellist and Invitees for that particular event. but due to multiple row items i'm not able to create the dynamic view for panellists and Invitees
Is there a workaround to show all this details?
I see. You could create a dashboard with three Dynamic Views, one for each of the sheets.
You could filter the dashboard a couple of different ways:
If your initiators have view access to the 3 source sheets, you could create a report pulling all 3 together and group it by Event ID so they could view all rows associated with that event in one group.
Dear All: Good morning. We are VERY close to getting the approval from my top management for DataMesh - this is something I have been hoping to get for us since 2019. We were able to help 4 departments set up and become power users of Smartsheet last year. DataMesh will allow easier and faster inter-departmental data…
Can Document Builder be automated so that after a form is filled out the document is automatically created and sent to the person who filled out the form (or any other identified person)?
I have a DataShuttle workflow where users attach a spreadsheet to an intake sheet. Question1: If multiple spreadsheets are attached to the intake sheet (via a form) does the DataShuttle workflow queue up these attachment imports? Question2: If you have to attach a spreadsheet and wait until the workflow completes, how does…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.