I have a matrix table of text entries with numeric values to be entered in each box. In workflow, I have math operations to sum each row. Works great thanks to help from the community!
BUT, is it possible to somehow ‘lock’ the math operation so the piped text that indicates the row number does not change every time there is an edit made to the form and published?
Below shows Nominee 2 piped in now as value ‘377’ instead of the original ‘2’ after someone made some edits and published. I now have to edit every operation so the correct new value is shown.