Update request - add field from other sheet

Titania Suwarto

Hi, is there possible to add fields from other sheet (i.e. sheet B) to an update request from a sheet A?

Bassam Khalil

Hi @Titania Suwarto

Hope you are fine, Unfortunately, this feature is not currently available but you can workaround by using cell linking to get that field to your A sheet. then you can add it in the form.

Andrée Starå

Hi @Titania Suwarto

I hope you're well and safe!

Do you only need to show the information?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Titania Suwarto

Nope, they need to fill the form. Let say I have Column #1 to #10 that generated from the form (need to be filled by contractor) and column #11 to #20 are the reviews & comments of the Column #1 to #10 that need to be filled by the Lead Agency. So the workflow is data validated -> Approval request and update request (filled the column #11 to #20 but locked the column #1 to #10) to the lead agency -> if declined send the update request to the contractor so they can update column #1 to #10 but I want the column #11 to #20 to be locked. Is there a way to do the last step? I managed to do workaround for the first UR

Andrée Starå

@Titania Suwarto

You could use the Placeholder feature combined with automated update requests for different roles.

Make sense?

Would that work/help?

Andrée Starå

More info: 

https://help.smartsheet.com/articles/2477796-dynamically-add-cell-data-in-the-subject-and-body-of-request-messages