Hello, I am new to Appsheet so I donโt know if I will be able to explain the situation correctly, it is kind of complexโฆ but here it goesโฆ
Consider the table below:
Sheet1
Email Groups Day1 Day2 Day3 Day4
Email1 Group1 Yes No No No
Email2 Group2 No Yes No Maybe
Email2 Group2 No No Yes No
Email3 Group3 No No No Yes
Email4 Group4 Maybe Yes Yes No
Sheet2
Day_1 Day_2 Day_3 Day_4
Group1 Group2 Group2 Group2
Group4 Group4 Group4 Group3
I built an condition in which the user can only see the rows which his email is written (changeable only by admin)
inside Data>Sheet1 I tried to make an โeditable ifโ in the Day1 column using CONTAINS(Sheet2[Day_1],[Groups]) formula. Theoretically, only members from Group1 and Group4 would be able change their status (โYesโ, โMaybeโ respectively) in Day1.
BUT IT DOES NOT WORKโฆ
Then I tried to perform IN([Groups],Sheet2[Day_1])โฆ applyโฆ andโฆ DOES NOT WORK AGAIN!!!
However, when I run the test for all cases, the results are correctโฆ It shows that only members from Group1 and Group4 can change their values in Day1.
I even tried to apply the same thought on Day2, Day3 and Day4โฆ NOTHINGโฆ
Please, give me light on this subjectโฆ I am stuck for more than 2 weeks on thisโฆ If you need more details, just tell me. TY
How? Please post a screenshot showing the configuration used to accomplish this.
No need screenshot for thisโฆ you just use CONTAINS([Email],USEREMAIL()) on the security filterโฆ voilรก
User | Count |
---|---|
43 | |
28 | |
24 | |
24 | |
13 |