Use a form to lookup sheet data that and add content to it

JTrumble

Hello,

 

I have read the forms with the “VLOOKUP” and “LOOKUP” functions.  I am new to smart sheet, but not to excel formulas. 

I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have.

Next step is the associate that repairs the cart, I have a report for them to look up the cart number to see what is wrong.  They can click on the cart number and add a comment to the sheet, I want to use a form for this though.

I would like to have a form, enter the cart number to the sheet data of the inspection associates results,  see what needs repair from the inspection associate.  Then after the repair, enter the status of the repair and what was fixed.

 

Is this remotely possible ??

Shaine Greenwood

Hello,

You can accomplish this with a combination of forms and either having them go into the sheet directly, or giving them a published sheet to view. More info on published sheets is available here: https://help.smartsheet.com/articles/522078-publishing-smartsheet-items

Essentially, they're still going to need to go into the sheet for the associates results.