On one of my sheets, I am summing a range based off of another columns date range and another columns value (true/false).
Currently, the formula I am using is:
=SUMIFS({JOBS AWARDED Lighting}, {JOBS AWARDED Bid Date}, AND(@cell > DATE(2020, 1, 1), @cell < DATE(2020, 12, 31)), {JOBS AWARDED Range 4}, @cell = 1)
However, there are times when the data I need is another another column other than {JOBS AWARDED Lighting}. So for a given row, we might have a value in the column {JOBS AWARDED Lighting}, but IF a value exist in another column, I need it to use that value instead of the one in {JOBS AWARDED Lighting} for that row.
How can I do that? I am unable to wrap my head around it with the syntax Smartsheet's uses.