To use a formula column to update a status column

[Krishele (Krishele Guzman)]

Check out this other post, I think it’s what you’re after.

Formula Column to Assign Numeric Values

Hi, We’re using monday as a CRM and as we grow the number of leads in our system, we need a way to prioritize them. I want to use the formula column to build a lead scoring system. For example one part of the lead scoring system might look like: If the status = decision maker, then 5 points If the status = likely decision maker, then 4 points If the status = Not a decision maker, but an influencer, then 3 points If the status = Unlikely to be a decision maker, then 2 points If the status …