is it possible to have different formulas for different rows in the same column? for instance, I have 4 groups of rows and in a given column, I want a different formula for each row group. if yes, how do I do that?
thanks
No, you cannot have different formulas. But you can use the same formula that evaluates differently depending on group. Use If() or Match() functions to build conditional formulas,
Example:
If(:group=="A", :X+1, :group=="B", :X+2, :group=="C", :X+3, :group=="D", :X+4, 99999)
