Change status based on a dropdown column using formula

Platform discussions
, ,
1

Hi there,

I hope someone can help me with this. Is there any way to use the formula to do the following:

If column A (=dropdown column) has more than 1 value then change the status of column B to “xx”

Thanks!

2

Hey @MB2202,

Currently it isn’t possible to trigger a column change (in your case, status column) using the formula column (natively). That being said, there is an app available via our apps marketplace called General Caster, that you might find relevant? It enables you to utilise formulas, to cast results to different columns. You can learn more here: https://generalcaster.app/

3

hi @BiancaT do you know if general caster can take 4 formula columns and and trigger a status? For example we have 4 formula columns with Red/Yellow/Green set up - I need a way to update a status when they all turn green, but also
update the status if any of the 4 turn yellow or red.

condition

Thanks!

4

Hey Sara,

I’ve had a little play around with GC and I am afraid I don’t think it’s currently possible to update the status based upon a value in the formula column :confused:

Would you be able to share the formula you’re using and any additional columns incase there is a suitable workaround here? :pray:

5

Hi Manuela,

You could do it with the Advanced Formula Booster.

2023-11-22_06-36-07

6

Hi Sara,

Same response as for Manuela. It can be done with the Advanced Formula Booster. If you want to share your formulas, I can show you how it can be done.