Help with an inventory tracking formula

steve50951 ✭✭
edited 12/09/19 in Formulas and Functions

i have created a sheet that will track inventory for a given property. I am having to cut and paste information from an excel spreadsheet (from our supplier). I have some formulas built in to the sheet that will calculate if a given line item is checked off as completed.

If the information pasted into the sheet extends beyond the copied formuals, obviously the formulas dont apply the informaiton below the formulas.

Is there a way to apply the formulas to the entire column, so no matter how rows are copied into the sheet, the formulas will be applied.

I have attached a few screenshots to show how im using the formulas.

Thanks for your help.


Screen Shot 2019-06-04 at 2.30.33 PM.png

Screen Shot 2019-06-04 at 2.30.48 PM.png

Screen Shot 2019-06-04 at 2.31.06 PM.png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!