SmartsheetGOV - Cross Sheet Reference Token Broken?

TinaMontgomery

Hi, I am working on setting up cross sheet references in SmartsheetGOV and it seems that the #UNPARSABLE error I receive is pointing to the token being broken. My formula is below. When I enter in "reference another sheet" it takes me through the steps to reference, but then it is inserted into the formula as plain text not as a hyperlink. Can I get some help to resolve this?

=IF( ISBLANK([Week Start]@row ), "", SUMIFS( {TM Schedule - Effort Driven Range 1}, {TM Schedule - Effort Driven Range 2}, Resource@row , {TM Schedule - Effort Driven Range 3}, ">=" + [Week Start]@row , {TM Schedule - Effort Driven Range 3}, "<" + DATEADD([Week Start]@row , 7, "days") ))

Paul Newcome

It looks like you are using Excel syntax instead of Smartsheet syntax. In Smartsheet, there are no quotes around operators, you don't "add" the operators, and there is no DATEADD function in Smartsheet.

Try this instead:

=IF([Week Start]@row <> "", SUMIFS({TM Schedule - Effort Driven Range 1}, {TM Schedule - Effort Driven Range 2}, Resource@row, {TM Schedule - Effort Driven Range 3}, AND(@cell >= [Week Start]@row, @cell < [Week Start]@row + 7)))