Formula Help
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...
Forum Discussion
You can use a formula numeric field to calculate the days overdue, [Late]:
If(
ToDays([Due Date] - Today())>0,0,
Abs(ToDays([Due Date] - Today())))
Then you can set up a notification to fire when [Late] is greater than 0.
If you are wanting to automate this then you will have to have a table connection or sync in order to set up a refresh schedule.
If(
ToDays([Due Date] - Today())>0,0,
Abs(ToDays([Due Date] - Today())))
Then you can set up a notification to fire when [Late] is greater than 0.
If you are wanting to automate this then you will have to have a table connection or sync in order to set up a refresh schedule.