Formula that will add 1 to a Qty row

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

Newbie to Smartsheet...I am wanting to write a formula that would at a quantity of 1 if the prior column has a date in the cell. I am trying to calculate the # of installations. basically if a date is entered into an install date column, I need the formula to add a quantity to a install quantity column. 





Screen Shot 2018-07-24 at 2.32.19 PM.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!