Change status when a number changed in other column

Feature requests
, ,
1

We would like to have a feature that automate change the status based on a certain changes on other column.

Like the sample below, if “Task progress” value change to ZERO, status will be changed to something, if value changed to ZERO but less than 100, status to change to something, if the value was set to 100, status will be changed to something…

image
image1247×397 57.4 KB

2

Hi,

You can achieve this by creating a formula column with the formula:
SWITCH({Task Progress}, 0, "Done", IF(AND({Task Progress} > 0, {Task Progress} < 100), "Working on it", IF({Task Progress} = 100, "Stuck", "")))
The formula uses a SWITCH function to evaluate the {Task Progress} column and returns a corresponding status label based on the given task progress.

  1. Updating the status column with the formula result when the Task Progress changes requires using a custom recipe built into an app we built, Formula Pro. You can find it on the monday marketplace, and there’s a free tier to get you started.

  2. When formula column changes, project result to column. You can update the custom recipe to suit your use case in this way.

    When {Task Progress Formula} changes, project result to {Task Status}

Once you have that wired up correctly, you will see the result.

Let me know if that helps.

Cheers.

3

Hi @Yahyasms
You can try the following formula
IF({Task progress} = 0, “Status_1”, IF({Task progress} < 100, “tatus_1”, IF({Task progress} = 100, “status_2”, “Default Status”)))

If you need any implementation support kindly contact us

MSquare Support
Visit us here
Youtube Channel