Updating a status based on the result of a formula that is a Date

Platform discussions
, ,
1

Having researched this extensively in this forum i am finding similar situations but mine has a slight twist.

Here is what i have.

I need to update the status of an item based on a date coming due.
For example a certain date arrives > change status.

This seems all very straightforward until you hear that the date in question is generated by a formula.

I am having a hard time figuring this one out, attached is a graphic that might help explain the situation.
The Green box indicates the desired end result (I manually changed the status for the sake of demonstration)

Screen Shot 2023-02-14 at 11.44.46 AM
Screen Shot 2023-02-14 at 11.44.46 AM2083×1128 311 KB

2

@vsav

There is currently no way to do that with base monday. You will need to either create a custom solution using Make or similar OR use an app like General Caster.

Jim - The Monday Man
We Create Custom Apps, Integrations & Automations for monday
What is Make & How can it help you with monday?

3

Thanks JCorrell.

Am i just overthinking this problem?, if i were to start again (which i can) would there a better way to achieve this?

4

@vsav,

If you have to have the date calculated I don’t see any other option. Perhaps you can share the formula.

5

Thanks.

I just need a date set three weeks before the “Install Date” (which is set manually)

Here is the formula i use in that column at the moment.
FORMAT_DATE(SUBTRACT_DAYS({Project Install Start Date},21))

6

@vsav

In that case, just use a custom automation like this:

image

Jim - The Monday Man
We Create Custom Apps, Integrations & Automations for monday

7

I am such an idiot, Thanks for that.

Got so deep into this i couldn’t see the simplest solution!