I'm trying to make the formula in the first photo refer back to the amounts listed in the second photo and sum the amounts in Contract Terms if the Contract Type is either Flat Rent or Enforcement Only. I feel like I have the formula correct, but it's still showing $0, despite having data in the columns to sum. The sheets are saved, I confirmed that the Contract Terms don't have spaces before/after. I'm not sure what else to check.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!