你好!架后ing my brain I'm just not sure this formula is possible. I have a workaround but it would be great if anyone could help me crack this mystery! The goal of this formula would be for it to 1) Read the numerical value of the "Level" (LVL) cell in order to determine the requirements 2) Include the numerical…
There are two columns with formulas that I am looking to incorporate adding not only a dollar sign ($) but also a comma (,) to properly represent US currency. The LVL or Level column represents a current level. Each level has a different threshold requirement that must be met for both Current LO MRR$ and Progress to LO…
你好!Currently I am building a formula to identify, based on a Partner's current tier, how close a Partner is to achieving the next tier by obtaining the total number of certifications needed to advance. Example: Partner X is currently "Registered" tier which is Level (LVL) 1. In order to advance to the next tier they…
Hello All, After running into a dead end, I am in need of some guidance. Currently I am trying to find a formula solution that will flag a cell, if a Partner tier/ level decreases in another cell. The sheet I am using is linked to another sheet that tracks the Partner's current tier/ level, which is updated weekly. At…
