Adding 30%

Graham Cracker
Graham Cracker ✭✭✭✭
edited 09/14/23 in Formulas and Functions

Need help adding 30% to the Buildout Cost when "Union Labor" is selected.

The formula I'm using is just giving me 30% of the value, not adding 30% to the value:

=[Square Feet]@row * (IF([Cost per Sqft]@row = "Aesthetics Only $125/SF", 125, IF([Cost per Sqft]@row = "Aesthetics w/ Plumbing $150/SF", 150, IF([Cost per Sqft]@row = "Partial Build $225/SF", 225, IF([Cost per Sqft]@row = "Full Build $325/SF", 325, IF([Cost per Sqft]@row = "Full Build w/ Demo $350/SF", 350)))))) * (IF([Union Labor]@row = "Union Labor", 0.3))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!