Conditional formatting depending on date created
I am busy creating a system where documentation needs to be collected before an application can be made for a loan. User phones client, creates client profile, then I need it to create conditional formatting after 3 days has passed to remind user to contact client and request outstanding documents. Cannot get conditional formatting to appear after 3 days.
Define a date field that records the date. This field can often be set to auto-enter the creation date so that the user does not have to enter a date except in unusual situations.
Then a conditional format formula such as:
(Get ( CurrenDate ) - YourTable::DateCreated) > 3
will result in a conditional format being applied on the 4th and subsequent days.