Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SUM IF & LEFT @cell
I keep getting the result of 0
I am trying to sum a range if another column contains "Street Lighting"
I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below.
=SUMIF(Team:Team, LEFT(="Street Lighting", [Days to respond]2:[Days to respond]4))
=SUMIF(Team6:Team45, LEFT(@cell, 5) = "Street Lighting", [Days to respond]2:[Days to respond]4)
Can someone please advise what I am doing wrong?