Formula ideas

Stacy Meadows
Stacy Meadows ✭✭✭
edited 11/29/22 in Formulas and Functions

So here goes;

sales sheet - contains sales monthly by postcode (RevPC} and name {RevPN}

Sheet B - wants a formula to pull monthly rev data from the sales sheet if postcode and name match

I just cannot get it right and cannot think where to start whether if statement and vlookup etc, sumifs .... help please??


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!