BrandonPorterQrew Trainee7 years agoDate Calculation for Formula Checkbox fieldI am trying to build out a To-Do app, and I want to sort by Tasks that have a due date within 7 days of the current date. My idea was to create a Formula-Checkbox field with an if/then statement that...Show More
QuickBaseCoachDQrew Captain7 years agoHere is a formulaIF(Today()-[Due Date] <= Days(7), "Due within 7 Days", "Not Due within 7 Days")
Related ContentCheckbox Formula - only pertinent recordsFormula to Calculate percentage based on Checkmarks and datesConditional formula urlYear Formula helpCheckbox 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