I am new to Smartsheet and was hoping someone can help with this logic expression, or let me know if this is even feasible.
We inspect equipment (blue light emergency towers) bi-weekly. I would like to create a sheet that shows these inspections and automatically creates a work order/assignment for our various repair technicians for any noted deficiencies.
I have created a sheet with the parent row serving as the individual inspection site, and the child rows are each of the weekly inspections. I have setup a rule to send out an update request if the inspection is within 3 days due, and our team is able to conduct their inspection. (That part makes sense and is an awesome feature - thank you Smartsheet!).
In order to better visualize my data and understand the status of our blue light towers, I would like to automatically populate the Parent Row inspection question cells with the data from the most recent inspection.
Is there a way to have these cells automatically populated with the last inspection data (e.g., if child cell is blank, populate parent with data from last child row with text)?
Thanks!