I am trying to create a workflow in bridge between Resource Management (to pull actual approved hours) and Smartsheet. There are not clear instructions on the different types of modules for the Resource Management step. For instance, I can get my workflow to run correctly IF I have a Smartsheet setup first (which requires a manual export of data from Resource Mgmt and then copy and paste into Smartsheet), but the problem is, when I get to the resource mgmt piece, I can fill out the following fields, but....where does the data go and/or where is it going!? I can't figure this out to save my life. The "incurred hours" are the "approved hours" and this total in the red box matches what is in RM, but how can I get that information to automatically pull from RM into Smartsheet without having a manual sheet setup?
Could I simply just have a project sheet in smartsheet listing all of my projects and the total hours per project get pulled in using the bridge workflow as long as i have an "incurred hours" column? I am really stuck on this and we need this missing piece to fill in a HUGE gap.
If I'm understanding you correctly, then yes! You can grab thedata referencethat you've circled from the Run Log to then eitherUpdate a rowor add as aNew Rowin a specific Smartsheet sheet.
列可以titled "incurred hours" or anything else that you'd like, as long as you map the data reference to the correct column name in your Smartsheet update/add module.
Let me know if that helped or if I can clarify further.
@Genevieve P.Thank you! I'll give this a try (and keep you posted if it works). Do you know once the workflow is created and I refresh it, that every time there are approve hours, it will pull those from RM into Smartsheet?
This would depend on how you've built the workflow: what yourtriggeris and what the end output is set up as. If you're manually running the workflow, and you've built in a module that grabs that data and puts it in a sheet, then yes, when you run the workflow it will grab any new data and put that into your sheet.
You can also trigger your workflow in different ways, such as through the Resource Management extension when a Project is updated or when Time Entries are updated:
Genevieve P. Employee Admin
