How to Apply Formula in Check Box Columns in Reporting Matrix/Writeback Matrix

We can apply formulas in Check Box Data Input columns so that whenever we tick a checkbox it creates the desired change in another Data Input column. This is a very useful feature especially when we want to link the Check Box column to another Data Input column in which we want the changes to be applied too.

We will understand this with an example.

1) Say we have a Check box Data Input column, and a Single Select Data Input Column:

2) In the Single Select Data Input Column we have three options - 'Option 1', 'Option 2', & 'Option 3' like shown below:

3) Let us say we want to configure the Checkbox Data Input column with the Single Select Data Input column wherein whenever we tick a checkbox, a Single Select option gets added automatically in the Single Select Data Input column and whenever we unselect the same ticked checkbox, another Single Select option gets added automatically. This can be achieved by adding a Formula within the Check Box column under the On Change Formula section:

4) We have applied the below formula inside the Checkbox column. In the below formula whenever we tick a checkbox 'Option 1' gets added automatically in the Single Select Data input column and whenever we unselect the same ticked check box 'Option 2' gets added:

5) How this formula works is when we tick a Checkbox the 'Option 1' Single Select option gets applied automatically:

And when we unselect this Checkbox the 'Option 2' Single Select option gets enabled automatically:

6) We can even apply formulas to other Data Input columns. In the below example we have Data Input Number column called Units Sold Input Column:

7) Now we have created a checkbox column for the Units Sold - Input Column called Units Sold Check Box column. We can apply a formula in the Units Sold Check box column using the Units Sold - Input Column:

This is our formula:

8) When we tick a checkbox, the value becomes 15000 and when we unselect the checkbox the value becomes 45000:

FAQs:

Can we add formulas in Checkbox columns using Native Columns?

No, we cannot apply formulas using Native columns. This can only be used with other Data Input columns.

Can we apply formulas in Checkbox columns using Visual Columns/Measures, Calculated Rows or Static Rows?

No, we cannot apply formulas using Visual Columns/Measures, Calculated Rows or Static Rows. We can only use Data Input columns.