DATE TIME UPDATE CONDITIONS

[Sirfyaad]

IFS(ISNOTBLANK([PUTAWAY NO]), NOW(),
IFS(ISNOTBLANK([SHELF CODE]), NOW()) 

 I want that when I edit [PUTAWAY NO] and [Shelf code] then only date time should be entered. But here the function is not working can you tell what mistake I am doing. 

[dbaum · Accepted solution]

At least in part, the answer depends on in what column "only date time should be entered"--as well as probably other aspects of what you're trying to accomplish. You may need something similar to one of the following.

IFS(
ISNOTBLANK([PUTAWAY NO]), NOW(),
ISNOTBLANK([SHELF CODE]), NOW()
)


IFS(
OR(
ISNOTBLANK([PUTAWAY NO]),
ISNOTBLANK([SHELF CODE])
)
,
NOW()
)


IFS(
AND(
ISNOTBLANK([PUTAWAY NO]),
ISNOTBLANK([SHELF CODE])
)
,
NOW()
)

[Sirfyaad]

Thank U @dbaum