Add Ons and Integrations

Add Ons and Integrations

Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

Is it possible to use Data Mesh without existing data in the target sheet?

✭✭
edited 06/14/22 in Add Ons and Integrations

Hello! I am trying to create team specific iCals from a company wide PTO request sheet. As iCalendars cannot be created from reports, I am trying to use Data Mesh to pull PTO information from a report showing just approved PTO from all people on a specific team to a separate sheet with just that team's approved PTO. But because the existing team sheet is currently blank, nothing is copying over. The setup I am going for is this:

All-Team PTO Tracker - All PTO submissions go here

  • Approved PTO Report: Team Name - reports for each team pull only the details for PTO requests that have been approved for people on the applicable team
  • Approved PTO Calendar: Team Name - Data Mesh pulls data from the team reports and copies into the individual team calendar sheets that can then be turned into iCalendars

I am trying to avoid overcomplicating this as the only other solution I've been able to come up with involves 2 different data shuttle configurations for each team. If anyone can help me come up with a solution for this, it would be much appreciated!!

Best Answer

Answers

Trending Posts