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.

SumIf across SmartSheets

Robert Railey
edited 12/09/19 in Archived 2016 Posts

Is there a way to create a sumif formula that references cells on a different sheet.  

If I'm entering the formula on worksheet2 but suming values from worksheet1 column2 if worksheet1 column1 values  match worksheet2 comlumn5 values.

Example:  =Sumif(sheet1!column1:column1,column5,sheet1!column2:column2)


I can't figure out, or find, the correct syntax for this.






This discussion has been closed.