I was hoping i could create a way to update a sheet with fixed records using forms

SmartSheetTesting

If I have a smartsheet with fixed number of rows with some content already fixed in some columns.

I need to add more content - two fields Score and Narration to each row.

But i want to have a Form 1 update column say 10 & 11 but only if 9 is present/matches user

Form 2 to update 13 & 14 but only if 12 is present

Form 3 to update 16 & 17 but only if 15 is present

And Master Form to update all fields when 1,2,3 have finished.

Can smartsheet do this ?

And can this be driven row by row ?

Intern98

you can use the logic portion in forms to show certain column when a set condition is met.

Andrée Starå

Hi @SmartSheetTesting

I hope you're well and safe!

Have you explored using Update Requests instead?

Would that work/help?

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 support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!