Hi there, I am quite new to your product, so I beg your pardon if I am mistaken about what is currently possible.
-
I believe that conditional formatting requires a constant, rather than e.g. a comparison to another column.
-
I also believe that it is not possible to hide columns.
Given this is correct (?) if it was possible to change these I think it would allow considerably greater expression.
For instance, assuming I have a column with rates which have row-specific thresholds (in a separate column), where I want to highlight where a threshold has been reached, I could:
a) Create a column with the diff of the rate and the threshold
b) Hide that column
c) Highlight the rate column conditional on the diff column.
My hunch is that this might be easier to produce than dynamic relations between columns for conditional formatting.
Is it possible that this could be available in the medium term?
Alternatively, if a similar solution already exists, and I’ve missed it, it would be very kind of you to forgive my ignorance and let me know.
Finally, thank you for the great product and project, it greatly simplifies my working life!