I'm hoping someone can advise how to get around this issue.
I have a new sheet I'm creating which acts as a checklist in a fixed process. i have several columns which cover off stages in the process, and there is a master flag as well which sets its status based on where there other stages are at. This Master Flag will then link its status to another sheet
Each of the stage flags has a default formula entered:
=IF([xxxxxx]yyy = "Yes", "Hold", "No")
which essentially defaults the initial value to "No", until such time as the preceeding stage flag is set to "Yes", at which point it sets the default to "Hold" until that task is completed and the user manually selects "Yes" from the dropdown in that cell.
(There will be some additional flags (for future development) which will tie into triggering the master flag, so the same issue will affect these as well.)
This all works perfectly how I want it to, except when it comes time to enter a new line at the top. The Autofill Formula works fine for the master flag as it never changes, thus the next 2 lines will always be the same and the Autofill works away as normal. For the stage flags though as the following 2x lines could be at any mix of stages it doesn't trigger the Autofill Formula for any cells where there is a mismatch.
This also occurs if a new entry is made through a webform. I tried entering the formula as the default value for the field, however on the webform it only permits one of the three default values for the data type and will not allow a formula to be added as the default.
My only workaround for the time being is to keep 2x lines at the start of the sheet which hold the defaults and when need a new line it has to go in at line 3 (references the two lines above for the Autofill Formula). It would be ok if I was the only person using this sheet, however there will be multiple itterations of this sheet for different people & each of those will be accessible by at least 3-4 people, so I can't trust everyone will remember to add at line 3 correctly.
If anyone can advise a solution I would appreciate it very much!
Development Team - would be great if you could allow formulas in webforms for hidden fields with Symbol data type.