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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!