When I create an If Then Else column, even if the condition isn’t true for every row, my data sheet immediately fills in the same answer for each row. I have 3 cases in my If Then Else column. If it helps, the condition I’m using is pulling from the User Profile sheet. I want to use this condition to decide whether or not to display a row in the app. One of my Zapier Zaps takes about 15 minutes to update, so I don’t want row data displayed until my Zap writes to my google sheet (that’s the idea behind creating this column, which I would then use to Filter displayed data in the app).
In my screenshot, you can see the 3 cases and how when I created the 2nd case, the entire column filled in with Silver even though not all of the rows have bought the silver package.
As you can see from screenshot two, items should definitely be able to If Then Else properly, unless I’m missing something.
Thanks in advance for any suggestions!