How do I write a IF statement from one sheet to another

msal

So pretty much, how do I get John Smith, Dean Smith with DCI product total of 7280+3952 into the sheet below with a IF statement?

also for Jaden and Bobby Smith with ACI product total of 3952+3952 into the sheet below with a IF statement?

msal

So a if Statement that will say If resource name has a Product of DCI THEN the total by resource and product total should = into the sum of forecast by product sheet

hollyconradsmith

Hi there, @msal,

Check out these articles. They should get you where you need to go!

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

https://help.smartsheet.com/function/sumifs

Genevieve P.

Hi @msal

I agree with Holly! A cross-sheet SUMIFS formula should be able to bring the content back for you. Try something like this:

=SUMIFS({Forecast Total Column}, {Product Column}, [Primary Column]@row)

The first article Holly mentioned explains how to create {these} across sheets, pointing at the right column. The second article describes the structure of a SUMIFS.

If this hasn't helped, let us know what we can clarify further for you!

Cheers,

Genevieve