IF with Summary Sheet Information

=IF(Jan2 >= 1, [Baseline = 1-250 Devices Shipped]#, IF(Jan2 <= 250, },[Baseline = 1-250 Devices Shipped]#), IF(Jan2 >= 251, [Tier 1 = 251-500 Devices Shipped]#, IF(Jan2 <= 500, [Tier 1 = 251-500 Devices Shipped]#), IF(Jan2 >= 501, [Tier 2 = 501-1,000 Devices Shipped]#, IF(Jan2 <= 1000, [Tier 2 = 501-1,000 Devices Shipped]#), IF(Jan2 >= 1001, [Tier 3 = 1,001-1,500 Devices Shipped]#, IF(Jan2 <= 1500,[Tier 3 = 1,001-1,500 Devices Shipped]#), IF(Jan2 >= 1501, [Tier 4 = 1,501-2,000 Devices Shipped]#, IF(Jan2 <= 2000,[Tier 4 = 1,501-2,000 Devices Shipped]#), IF(Jan2 >= 2001, [Tier 5 = 2,001-2,500 Devices Shipped]#, IF(Jan2 <= 2500, [Tier 5 = 2,001-2,500 Devices Shipped]#), IF(Jan2 >= 2501, [Tier 6 = 2,501-3,000 Devices Shipped]#, IF(Jan2 <= 3000, [Tier 6 = 2,501-3,000 Devices Shipped]#, 0)))))))))


Returning

#UNPARSEABLE

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!