Copying a Sheet & Using Formulas Changed the Form Attached to Original Sheet
Hi SmartSheet Community,
I came across an issue with copying a sheet and the form that was attached to the original sheet was modified from using a formula in the copied sheet.
Original Sheet Name: IHA
Copied Sheet Name: Copy of IHA
INDEX/MATCH Sheet Name: Job Model
After I copied the IHA sheet (File --> Save as New), I used an INDEX/MATCH formula in the Copy of IHA sheet with the Job Model sheet. Somehow, the fields (Job Position & Grade Level) I used the INDEX/MATCH formula in the Copy of IHA sheet had hidden those fields (Job Position & Grade Level) in the form from the original sheet. I compared the two forms - IHA and Copy of IHA -and the URLs were different, so that was not the issue. I had to go into the form and just click "Hidden" to unhide the field because it was automatically selected to hide the field.
Has anyone else had this problem? I would like to prevent this from happening again, but I am not sure if it is out of my span of control or not.