This issue is somewhat related to what @nigel posted about in this thread. I am confused sometimes as to why
thisRow works vs. the column name when referencing column names in formulas. In this table below, I have a summary table at the top that sums up all the costs by person, and the table below shows all the individual costs:
The formula makes sense to me since you are comparing
Detailed Coststable with the
Peoplecolumn in the
Nameare of the People column format.
If I change the formula to use
thisRow instead of the column name, the formula doesn’t work anymore. I feel like it should, any ideas why?