Here the expression is working in the app formula. But when I use this function in Initial value, the expression here does not work. Why
IFS(
OR(
ISNOTBLANK([HANDOVER TO]),
ISNOTBLANK([NAME])
),
NOW()
)
IF(
OR(
ISNOTBLANK([HANDOVER TO]),
ISNOTBLANK([NAME])
),
NOW(), "")
Not working this, When I enter the handover to in the column, the date time does not appear.
Hi @Sirfyaad
Your formula in Initial value its correct and will work only if you add new row
1- VALUE_1 & VALUE_2 is balnk
2- VALUE_1 is not balnk there value "TEST", Value_3 its work
3- VALUE_2 is not balnk there value "TEST", Value_3 its work
----------------------------------------------------------
To solve the problem while edit the row. Add this formula on RESET ON EDIT
OR(
ISBLANK([VALUE_1]),
ISBLANK([VALUE_2])
)
NOT WORKING.
User | Count |
---|---|
39 | |
32 | |
30 | |
16 | |
14 |