DATE TIME UPDATE CONDITIONS

AppSheet AppSheet Q&A
, , , , ,
1 
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.

2

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()
)
1 Like
3

Thank U @dbaum

1 Like