Problem
If the Single Value Column is used to get a value from another sheet (where Row Owner is enabled), the single value retrieved will be from a different user.
Steps to replicate:
- Create 2 sheets (sheet A and Sheet B);
- In Sheet B, create a column “Email” and add 2 rows with different emails (Email 1, Email 2);
- Enable Row Owner for column “Email” in Sheet B;
- Now in sheet A, populate it with content so that it appears in Glide’s Data Editor;
- In Glide’s Data Editor, create a new column and select “Single Value” - configure it, by selecting: First, and select the column “Email” from sheet 2 as the second configuration input;
- Click Done after editing;
- Now in “Preview As”, enter the second email address, that is in the second row of “Sheet B”.
The outcome: Single Value column output will be the email found in row 1 in “Sheet B” instead of the email in row 2.
Expected behaviour:
The single value column output should reflect Row Ownership. Meaning: Single Value Columns respect Row Owner constraints (Full data ownership).
Current behaviour:
Single Value column output will be the email found in row 1 in “Sheet B” instead of the email in row 2.
Additional information:
Nothing to add