I have a table that is driven by due dates and would like to tack / capture the number of lates in a report or table. does anyone have any suggestions on best practices and how i might auto generate t...
This is the way i have it setup and it does not seem to be working properly. i assumed it was because the late status is triggered through a formula and within the automation it states to "trigger" when a user makes a change.
If i go in and change the dates manually to drive a "Late" status, it will populate the other table as it is intended but it does not work on its own.
to work this way i need a formula correct? or maybe i have something else that is not setup correctly?