Hi Faheem! 😊
It sounds like the issue you’re encountering is due to stale or outdated data in the column after using the conditional formula. When the data is outdated, you’ll need to update it manually, as the system can’t automatically refresh it once stale.
Typically, auto-update is enabled to prevent this, but since it’s already flagged for a re-run, go ahead and update the data again. Here’s a helpful example on handling stale data: Loom Video Example.
If you need more guidance or run into any other issues, feel free to reach out. I’m here to help! 😊