Editable If by user

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

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

Simon@1minManager.com

1 Like

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

Try this:

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

Hello Steve,

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

Thanks much!

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

2 Likes

Thanks a LOT ! it works :smiley:

1 Like