Miss_Priss✭✭

@Paul Newcome The [Accredited Individuals - Business] column cells are linked to another sheet which is updated weekly. The cell value ranges from a blank cell, and anywhere from 0 up. Let me know if I misunderstood your question.

@Paul Newcome Thanks for the response! This formula solved almost everything but for some reason it's not recognizing the zeros from this part of the formula IF([Accredited Individuals - Business]@row = 0, ".." I've tried to move some things around to fix it but I'm not sure where the problem is. Everything else works…

@Andrée Starå Can you please look at the above? I feel like my formula is close based on the outcome I'm looking for but I just can't quite figure out what's missing.

@Paul Newcome That did something but not quite what I had in mind. It looks like it wiped out the data for any LVL 1, which is not what I expected when I read the formula. I tried to make some changes but I guess I still can't get it quite right. There's a few things I want as a set response in different scenarios for this…

@Paul Newcome & @Andrée Starå - Thank you so much for your help! This worked like a dream. Now that I am taking this to the next level I've run into another challenge creating a comprehensive formula to get the result I'm looking for. The goal of this new column would be the calculate the compliance of the current level.…

@Paul Newcome - Any idea how to add the IF(ISBLANK to the beginning of this formula to result in a blank response if the certification cell ([Accredited Individuals - Business]@row) is blank? I've been messing around with this but I think I'm backed into a corner. I must be missing an element to make this a true statement.…

这是魔法!谢谢你u so much for cracking the case!

Sure, the snippet is now included for reference. The test column is where I've been working through the formula. Each LVL or Level has it's own requirements in order to progress to the next level. Ideally the formula I create will read as, if you are Level 1 for example you must have 2 of these Certifications (Accredited…

@Michael Culley You're amazing! I was wondering if I should use the + instead of a comma, but my thought was that I didn't want it to be a continuation of the math problem, so it didn't make sense in my head, lol. Still learning how to transition from an excel mindset to Smartsheet. Thank you for being my superhero for the…

@Michael Culley Thanks for catching that! That will teach me to multitask, lol. While adding the other levels & certification thresholds, it's caused another Unparseable error. In order to expand on this formula, what am I missing to add the additional arguments? Example below with levels 2-4 added. =IF(AND(LVL@row = 1,…