Need Initial value Expression

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()

)

0 4 138
4 REPLIES 4

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

V1.JPG

V0.JPG

1- VALUE_1 & VALUE_2 is balnk

V4.JPG

2- VALUE_1  is not balnk there value "TEST", Value_3 its work

V2.JPG

3- VALUE_2  is not balnk there value "TEST", Value_3 its work

V3.JPG

----------------------------------------------------------

To solve the problem while edit the row. Add this formula on RESET ON EDIT

OR(
ISBLANK([VALUE_1]),
ISBLANK([VALUE_2])
)

V5.JPG

NOT WORKING.

Capture.JPG

Top Labels in this Space