use Transform value on Conditional formatting tab#536
Hi Team,
An idea that can be very interesting is that we can use Transform value in Conditional formatting Tab.
For example, if there are zero values in the first column (name), the value of the second column (for example, full name) will be used instead of zero. This way, we can generate dynamic conditions based on the values in the conditions tab based on other table columns.
An interesting idea indeed, I sincerely hope we’ll be seeing something like that in the future. There could probably be many use scenarios.
This got me thinking though, could similar functionality be happening already when editing the values, i.e. before saving. So I’d figure it would then be more of editing modal thing than conditional formatting thing… I don’t know however which one could be a better approach in terms of usability and feasibility. Probably your suggestion, since the conditional formatting functionality already exists so it would be only about bringing in the Transform value placeholders.
A few related suggestions on conditional formatting have also been posted: #262 and #57