Hi all, I have a formula: =IF([New (Feb 2025) Account Coordinator]@row = "Carrisa Meeks", "GS 1 - WAREHOUSE") where if the column "New (Feb 2025) Account Coordinator shows Carrisa Meeks, then the cell…
I am tryings to create a risk formula for Program that has list of projects as a child. Following are conditions to mark the project as either Green, Yellow, Red or Blue: Blue: - Project has progress …
Hi Everyone, I'm looking to pull any trainings that were "Direct" from the Past 30 Days. Anytime I enter the formula it says #Unparseable. I'm not sure where I'm going wrong. =COUNTIFS({Training Type …
While researching a problem I had and the absolutely simple solution that was causing it, I decided I would write this post to help people in the future. This is not an official post, just me trying t…
I am trying to use an IF statement in the approved column that says "If status is requested, return PIPELINE, all other statuses return APPROVE, unless it's blank then leave the cell blank". Everythin…
I would love to be able to take action within a formula based upon which specific error the formula spits out. Right now, the IFERROR function catches errors but doesn't tell us what kind of error it …