Smartsheet CountIFs

Options
kamnashah
kamnashah ✭✭
edited 06/13/23 in Formulas and Functions

I have 2 SmartSheets. The first one (Sheet1) has customer data with some transactional information ('Customer Number', 'Order Number', 'Order Number', 'Licenses Used', etc.). The second one (Sheet2) has all transactional information ('Customer Number', 'Part Number', "Serial Number', 'Entitlement Complete (Y/N)', etc.).


All I am trying to do is ...

'Licenses Used" = Count of 'Entitlement Complete (Y/N)" where 'Customer Number' are same in Sheet1 and Shee2.

I am new to Smartsheet and am struggling. Any help / guidance is appreciated.


-Kamna

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!