formula help

edited 12/09/19 in Formulas and Functions

i have a checkbox column that registers a check mark when an amount is over $100. The sheet has a form for collecting data. i put in a the formula =IF(Amount20 > 100, 1, 0) in the checkbox cell. Only when data comes in from the form, it puts new data at the bottom of the sheet below the formula. how do i get the formula to apply to the entire column, catching the new data coming from the form?




Screenshot 2019-05-22 at 1.59.34 PM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!