Good morning Smartsheeters,
I am using a sheet for my production team to log their hourly product inspections on. Basically, they will complete a form that will then log onto the spreadsheet; this works great.
What I would like to do however, is to save the operators time, have the first 2 columns, "part number" and "product order number", auto-populate based on the cell value in the cells directly above. So, the operator just has to put these numbers in once and not again on subsequent inspections. The part number isn't too much of an issue as it is typically only a few characters, but the production order number can be complex.
The deeper issue - on occasion, maybe once every 3 hours or so the part number and production order number will change - meaning that when the operator logs this change manually within the form, it breaks the formula chain for a simple formula such as =[cell above].
Is there any way around this? I was wondering if something along the lines of =IF(NOT(ISBLANK would work? I've tried but this is beyond my very primitive knowledge.
Any and all help is greatly appreciated.