AaronSnowQrew Cadet5 years agoFormula HelpI 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...Show More
AdamKeever1Qrew Commander5 years agoYou 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.
Related ContentConditional formula urlYear Formula helpFormula URL - Edit then AddCreate a formula duration over 5 yearsLooking for State abbreviation to full spelling formula
Recent DiscussionsCurrent URL Display without JavaScriptRemove the save button when from new forms format when applying I-forms (IFV=1) #354382Help Needed with Quickbase Pipeline to Accumulate Values Instead of OverwritingAPP - CommunicationsKanban WIP Limits