SUMIFS Formula issue

Options
refogleman91066
edited 12/09/19 in Smartsheet Basics

I'm trying to write a formula in Smartsheet where it pulls the cost of an asset into a column if it matches the request and the replacement year:

=SUMIFS([Vessel Replacement Cost]@row, [Replace Year]@row = "2021", AND(Request@row = "Replacement"))

This is pulling ALL requests into the column where the asset is a replacement no matter the year.  Not sure what is wrong with my formula.  Maybe I am overthinking this???

Comments