Checkbox Formula for entire Column

TroyT ✭✭
edited 12/09/19 in Smartsheet Basics

I am currently using something similar to the below to translate checkboxes to values, and am then concatenating those values:

=IF([Test 2]1 = 1, "Test 2:", " off ")

The problem I am running into is as new rows are made, the formula is not auto-populating the cells. does anyone know how to incorporate the above example, but with something like "=IF([Value Test]:[Value Test]...",

SS checkbox.JPG