Hello, I have scanned through previous posts and could not find one that matches my situation. I created a Metric Sheet which I want to pull footages from another sheet that fall within a date range. I followed the formula syntax and ensured my headers are correct and the format for date range is also correct but I keep getting a #UNPARSABLE error. I even tried to use AI and still I get the same error.
=SUMIFS({LSC-IN-CON-1.25}, {LSC-IN-CON Date}, ">=" & [Start Date]@row, {LSC-IN-CON Date}, "<=" & [End Date]@row)
The construction Metric Sheet:
The Referenced Sheet that has the Date and Footage:
Can someone please tell me what I am doing wrong? I can get this to work in excel, but the company I work for moved to Smart Sheets and I am having a real hard time converting many formulas.
Thank you,
Joe
