Hi community,
I have a form where the user can select one variable.
Depends of the selection, the following question has number inputs or yes/no option.
Number inputs:
Yes/No option:
When the user has the Yes/No option, I need the following behavior:
I tried the following formula in Data => ValorMax configuration => Auto Compute => App formula
IF([appSheetsBoolean]=Yes,
[valorMax]=1,
IF([appSheetsBoolean]=No,
[valorMax]=0,
[valorMax]=[_THISROW].[valorMax]
)
)
I get the following error: The expression is valid but its result type 'Yes/No' is not one of the expected types: Decimal
I am not sure if we are using the formula in the correct place.
Thanks for your feedback.
Solved! Go to Solution.
Set below in the initial value of valoMIN/MAX and see if it behaves as your expectations.
IF([appSheetsBoolean], 1.0, 0.0)
If you set the app formula, the user cannot edit the column.
Set below in the initial value of valoMIN/MAX and see if it behaves as your expectations.
IF([appSheetsBoolean], 1.0, 0.0)
If you set the app formula, the user cannot edit the column.
Hi @TeeSee1 , it works perfect in initial value as you recommended.
I used the following code:
IF([appSheetsBoolean]="Si",
1.0,
0.0
)
User | Count |
---|---|
37 | |
30 | |
29 | |
20 | |
18 |