Hi,
I want to make a manual record if conditional data records are not required, is this possible? (if and ifs)
Example:
=IF(NOT(OR([Test1]=“abc”, [test1]=“def”)), [temperature]=25, “manuel entry”)
I will enter the manually if the condition is not met
Thanks
I believe you could do that in two steps:
Use a conditional expression in Editable_If, so only when a particular condition is met it will allow data entry in that column.
Enter an IF() expression in Initial Value, to automatically fill the column’s value with a default you wish for cases that the above condition in step 1 is not met and user is not supposed to do manual entry.
Excellent solution, thank you very much.
@Test_Birimi you’re welcome!
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |