An automated workflow where data is updated to an existing sheet

SmartSheetTesting

Steps that i envisage

Load the smartsheet with predetermined data - say columns A to G

Create form for displaying columns A to D only and allow entry of column J and K

Create form for displaying columns A to D only and allow entry of column M and N

Create a workflow where person A is asked to complete cols J & K when col H = "John" using Form 1

Create a workflow where person B is asked to complete cols J & K when col H = "Mary" using Form 1

Create a workflow where person C is asked to complete cols M & N when col L = "Pat" using Form 2

Is this possible ?

SmartSheetTesting

Thanks James , your explanation is most valuable.

I have tried your method and I can see the logic. And it appears to work.

My problem now is that the first time it appeared to work but data entered did not update the original sheet

Further attempts to debug and the report loses the source sheet (columns and filter stay in place but source sheet is blank) - you mentioned 'pin the report' is this something i did not do?