Value source in Rules

When you want to apply rules based on data from other columns or rows

Value Source is usually available in rules that contain data-based visualization.

Usually the data you want to trigger the rule will be located in the cell you're applying the rule to, but sometimes that isn't the case! That's where Value Source comes in handy.

Value source is a property-field available in several rules, which makes it possible to make a rule trigger based on input from a different column or row than the cell you're applying this rule for specifically.

This can be especially useful if the trigger-conditions are located in one row/column but you want the visuals to appear in a different or offset cell, or you if you want a condition in one cell to trigger formatting for a larger area.

Usecase - Status

In the example above, we apply an Icon Conditional-rule to Column B, then use Value Source to make the text in column C affect the status icons in Column B.

When status description in column C is changed, it will now reflect the icons in column B!

Tip! 💡 
You can also use Value Source as a way to pull in data for visualization from hidden rows or columns