Hello! I would like to have an icon show up in a table if more than a year has elapsed since a defined date. I believe the correct approach is to use a Rich Text Formula field but I'm struggling a bit to construct the correct formula.
The defined date is "Last Raise" and I'd like a warning icon to show when today's date is 365 days or more after that date.
Here's my draft Rich Text formula (that doesn't work!) - I know it's because I'm mixing operators but I just can't figure out the solution. Thanks in advance for the assist!
If(Today()-[Last Raise]>365,"<img src=https://images.quickbase.com/si/16/241-triang_yellow.png>")
------------------------------
Eric Rovner
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.