sumifs formula cross-sheet

Melanie Sanders

Hi,

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.

Melanie Sanders

Hi @Christina Lam so today the formula is working.....go figure. Thank you for your offer to assist.

Christina09

Hi @Melanie Sanders,

To understand what's wrong, could you please tell us what is the error message?

ref: https://help.smartsheet.com/articles/2476176-formula-error-messages

Melanie Sanders

Hi @Christina Lam so today the formula is working.....go figure. Thank you for your offer to assist.