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

Options
✭✭

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?

• ✭✭
Options

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

• ✭✭✭✭
Options

Hi there, @msal,

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

Director of Technology & Innovation 💡 at Streamline

CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony

Options

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

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!