Solved: Initial values set based variable answers. - Page 2

Matt1228 · 06-27-2022 03:37 PM

Hi,

I want the to set the initial value based on 3 other true or false questions.

For example in "show" I have [MANAGER]="TRUE" then it shows the question for that role. I want the initial value to be set to "Required" for that question. The question then References a Table with a selection of answers. I tried setting the "Initial value" to Required for all of the questions but on the sheet document it fills them all in. Even the questions not pertaining to the role. So basically I am trying to get to a point where It fills in "required" for only the questions pertaining to that persons role. Another thing is some questions are for multiple roles. So for the "show" formula I have OR([CSR]="TRUE", [Manager]="true"). There can be questions only the CSR needs to see that should be set to "Required" initially.

Thanks

dbaum

It sounds like you want to repeat your Show if expressions within your Initial value expressions to create a condition for populating an initial value. For example:

IFS([MANAGER]="TRUE", "Required")

Also, be sure you're distinguishing between Initial value, which determines what value initially populates a column in a newly created row, and Require?, which determines whether a column must be populated when saving a newly created row.

View solution in original post