count days without formula (standard plan)

Platform discussions
,
1

hi,
is there a way to count the days from status change without using a formula (i’m a standard user, formula is a pro-feature). i need to automatically count the days that have passed from the moment the status changed.
thanks a lot!

2

Hey,

The fact is, you want to do an automation (When the status changes to… count days). This is something you can’t do with formula column, so don’t worry.

You need to use a 3-app like General Caster or Autoboost (let’s check it in the monday app marketplace).

I show you how to do it with Autoboost.

Step 1 : set a date column to today when the status change

Capture d’écran 2023-09-21 à 13.43.38
Capture d’écran 2023-09-21 à 13.43.381800×954 91.3 KB

Step 2 : Set a date to the today date (it’s changing every days)

Capture d’écran 2023-09-21 à 13.44.25
Capture d’écran 2023-09-21 à 13.44.251912×858 82.9 KB

Step 3 : Set this automation in autoboost

Capture d’écran 2023-09-21 à 13.45.57
Capture d’écran 2023-09-21 à 13.45.571254×596 15.5 KB

Capture d’écran 2023-09-21 à 13.46.27
Capture d’écran 2023-09-21 à 13.46.27894×304 11.1 KB

and that’s all !