formulas in columns<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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
formulas in columnsNo, 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)
