Why won't my data populate?
I'm trying to run a workflow to map data from an Excel file to a Smartsheet grid. I've taken the time to map the columns appropriately and created another column with ID numbers on both sheets that I hoped would serve as a reference point for the data to automatically populate. However, it's running for less than a minute and not updating any of the rows. The action I've selected the data to take is to merge data since I want to leave the other parts of the rows untouched. I just can't understand why it's not working.
Answers
-
Hi @Armando KMA
Welcome to the community! We're happy to have you here!
It sounds like there might be an issue with your workflow
1. Do you have both an offload and upload flow set up?
2. What are your triggers for the execution of the flows?
3. The workflow may not be correctly identifying rows for the merge operation if there are discrepancies in the ID fields (extra spaces, formatting differences, etc.). Make sure the IDs are exactly the same.
4. Check your permissions on the Smartsheet sheet, if you don’t have editing access, the workflow will not be able to update the rows.
5. If possible, check any error logs or notifications from the workflow to see if there are any specific issues reported. Sometimes, it may point out which step or condition is causing the failure.
I hope this helps. If not, feel free to schedule some one on one time in my calendar using the link below. I'd be happy to help you with this one.Marcé Holzhauzen
Solution and Delivery Consultant with Award Winning Partner
Want to meet?Check my availabilitywww.prodactive.co.uk
If this helped, help me & the SSC by accepting it and reacting w/💡insightful, ⬆️ Vote Up, and/or ❤️Awesome.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives