How do I write a IF statement from one sheet to another
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?
Answers
-
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
-
Holly Conrad Smith
Director of Technology & Innovation 💡 at Streamline
CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony
-
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!