Hello, not sure if this feature exist but I have not been able to sort it out. Our database is a collection of international contractors whom we use with varying degree. We store among others their passport expiry. Is there a way to set a reminder that would highlight a field or change color of the font, once the passport is expired.
At the moment our only choice is to be overflowed with emails reminding about expired passports, visa’s and trainings.
With a simple indicator like the first name in red, could remind our project managers that there are documents to be updated before assigning a specific individual.
Step 1. Create a date field with TODAYTZ() to get the date of today.
Step 2. Save the design first and run the formulas recalculation for the formulas you add in step 1.
Step 3. Create a “Check” free text field with IF() to compare if the passports are expired.
For example,
IF(A1<A2,“Expired”,“Valid”)
Please replace the A1 with the expired date of the passport while the A2 with the TODAYTZ().
Step 4. Save the design first and run the formulas recalculation for the formulas you add in step 3.
Step 5. Set the conditional formatting to highlight the field when the value of the “Check” field equals “Expired”.
In case you have issues when setting up above, please kindly let us know in which steps that you have the issue and share a screenshot of the error for us to refer to.