sumifs formula cross-sheet


I have a partially working formula from a cross-sheet.

=SUMIFS({VENDOR QUESTION Amount of Credit}, {Status}, OR(@cell = "Pending - With AP", @cell = "Pending - With Vendor AP"))

When I try and add in these additional columns, I get an error. {Location # and Name}, LOCATION@row

Any suggestions would be appreciated.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!