Why is formular working in some cells but not others?

I am using your "Annual Business Budget" template to which I added an 11th budget category, and a department column in the "Expense Intake & List" sheet. I am experiencing a problem with the Fixed and Variable expense formular not capturing the expense in the Budget and Tracking sheet.

=IF($Name@row <> "", (SUMIFS({Expense}, {Category}, $Name@row, {Period}, 1, {Type}, "Fixed")), "")

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!