Formula not updating row number when using a form

How about showing us your formula?

Is it a column formula or cell formula?

Did someone sort the sheet differently and move an existing row 1 someplace else in the sheet?

Are you familiar with column formulas, and using @row to make your formulas apply to every row without working about the position in the sheet? Here's a help sheet on it: https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Essentially, every place where you specify the row number in your formulas, replace the row number with @row. For example, in the formula you show, change to:

=IF(Hold@row, "ON HOLD", IF([Part Number Complete]@row <> "", "COMPLETE", IF(Complete@row <> "", "Part Number" ... and so on. Just do this on the top row of your sheet. When done, right click on the cell with the formula, and down at the bottom of the cell menu, select "Convert to Column Formula". The formula will then apply to every existing row in that column, plus all new rows that get created. And it doesn't matter where the row is in the sheet. You could move row 1 down to row 500, the formula still works.

Once you have column formulas in place, to change the formula for all rows, right click and choose "Edit the Column Formula," and any changes you make apply to every row immediately, no extra steps.

Happy to help. @row was a gamechanger when it came out, column formulas even more so. They save so much time and ensure things work as they should.