Formula Editor: help with using Subscript function dynamically
Hi all, I'm trying to compare across rows in my data table in a generalizable manner. To do this, I'd like to create a formula column that finds and returns a value from a specific row with certain traits. In this example screenshot, I would like the "Control Result" to be a formula column that returns the "Control" row with a matching "Donor" field, and return the corresponding "Result" score. I...