Hi,
I want to know how could to achieve the following,
I have a table where in a particular cell i want to add a editable_if expressionโฆhere i want it to be editable on when the value of another column in another table is for instance โPendingโ. If its โCompletedโ, i want it to not be editable.
The common info for both rows in both the tables is Order No
How to do this ???
Solved! Go to Solution.
Sure! If only one user:
AND(
(USEREMAIL() = "abc@gmail.com"),
(
"Completed"
<> LOOKUP(
[_THISROW].[Order ID],
"Anther Table",
"Order ID",
"Another Column"
)
)
)
If more than one user:
AND(
IN(
USEREMAIL(),
LIST(
"abc@gmail.com",
"def@gmail.com"
)
),
(
"Completed"
<> LOOKUP(
[_THISROW].[Order ID],
"Anther Table",
"Order ID",
"Another Column"
)
)
)
In both of the above, I made the assumption that you only want the column value editable if the user is one of the designated ones and the other tableโs column is not Completed
. If instead you want the column editable if one of the designated users or Completed
, change the initial AND
to OR
.
See also:
Try:
(
"Completed"
<> LOOKUP(
[_THISROW].[Order ID],
"Anther Table",
"Order ID",
"Another Column"
)
)
See also:
can i also add a particular user who can edit this like useremail()=โabc@gmail.comโ to the above expression
Sure! If only one user:
AND(
(USEREMAIL() = "abc@gmail.com"),
(
"Completed"
<> LOOKUP(
[_THISROW].[Order ID],
"Anther Table",
"Order ID",
"Another Column"
)
)
)
If more than one user:
AND(
IN(
USEREMAIL(),
LIST(
"abc@gmail.com",
"def@gmail.com"
)
),
(
"Completed"
<> LOOKUP(
[_THISROW].[Order ID],
"Anther Table",
"Order ID",
"Another Column"
)
)
)
In both of the above, I made the assumption that you only want the column value editable if the user is one of the designated ones and the other tableโs column is not Completed
. If instead you want the column editable if one of the designated users or Completed
, change the initial AND
to OR
.
See also:
User | Count |
---|---|
41 | |
35 | |
27 | |
23 | |
16 |