Don't Want Negative Numbers in a Numbers Column

I have a numbers column where we’re assigning a Baseline Effort Score for a project. In another numbers column I have the Effort Score that changes with automations based on the phase that the project is in. Is there any way to format a numbers column so the Effort Score never goes below 1?

Hi @ssandore :wave:

Welcome to the Community!

We can’t stop the functionality of the numbers column from allowing it to go beyond 0, however, we can set up automation to catch when this happening and work to mitigate from there.


Hope that if helpful, happy to chat further if you’d like to :slight_smile:

Peta | Platinum Partners | upstream
+613 9067 5611

1 Like