Help with this IF this then this formula

Please help me figure out what I am doing wrong with this formula:


=IF((([Size of Install]@row = "Small - Single Server, no HA, no NLB, HPAC PP+IA+, no HPAC Scan, no HPAC mobile connector, includes PPM/PDM, WJA, UPD, 500 printers or more - remote/travel extra, for small AlertX configuration only, single server for PP, IA2", 16), IF([Size of Install]@row = "Medium - Multi Server, HA, NLB, HPAC PP+IA+, HPAC Scan, HPAC mobile connector, includes PPM/PDM, WJA, UPD, 1000-5000 printers- remote/travel extra, Global, Azure/AWS", 24), IF([Size of Install]@row = "Large - Multi Server, HA, NLB, HPAC PP+IA+, HPAC Scan, HPAC mobile connector, includes PPM/PDM, WJA, UPD, >5000 printers- - remote/travel extra, Global, Azure/AWS", 40)))



Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!