Editable If by user

[Samy_Kermia]

Hello everyone,

I would like to use the editable IF column like this:

IF Line A is empty, User A and B can write
IF line A different from empty User A can write, User B can no longer write.

I tried that but I find myself in a situation where if the line is empty, no one can write …

IFS ([Line A] <> “”,
USEREMAIL () = A@gmail.com,
USEREMAIL () = B @ gmail.com, false,
USEREMAIL () = B@gmail.com, true,)

[1minManager]

IF(ISBLANK([Line A]),TRUE,
IF(AND(ISNOTBLANK([Line A]),UserEmail()="A@Gmail.com"),TRUE,
FALSE))

Simon@1minManager.com

[Samy_Kermia]

I can’t edit with all profiles if the column A is no empty

[Steve]

Try this:

IF
  ISBLANK([Line A]),
  IN(USEREMAIL(), LIST("A@gmail.com", "B@gmail.com")),
  IN(USEREMAIL(), LIST("A@gmail.com"))
)

[Joseph_Seddik]

Hello Steve,

Is there an advantage using LIST() instead of the { } notion in this case? I mean with IN()?

Thanks much!

[Steve]

In this case, no. I generally avoid the {} notation as a personal preference.

[Samy_Kermia]

Thanks a LOT ! it works