formula help

steve50951
steve50951 ✭✭
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?

 

thanks

SGF

Screenshot 2019-05-22 at 1.59.34 PM.png

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!