ContributionsMost RecentMost LikesSolutionsRe: Dynamic rule setting for rich text fieldGot it. Thanks for the pointer! I'll keep that in mind. ------------------------------ Joanne Wong ------------------------------ Re: Dynamic rule setting for rich text fieldThanks Mark. I tried what Evan suggested and it worked. ------------------------------ Joanne Wong ------------------------------ Re: Dynamic rule setting for rich text fieldThanks Evan. Actually I tried it again and it worked! There was probably an error in the formula I put in. Thanks for your help! ------------------------------ Joanne Wong ------------------------------ Re: Dynamic rule setting for rich text fieldThanks Evan. I did but the dynamic rule is still not working. ------------------------------ Joanne Wong ------------------------------ Dynamic rule setting for rich text fieldHi Quick Base Community! I'm trying to set up a dynamic rule for the following condition: When [Status] equals to "Renew", show [Has a renewal audit been scheduled?] [Status] is a formula rich text field and has the following formula: If(([When does the accreditation expire?]<Today()),"<div style=\"background-color:red;width:10\">Expired</div>", ToDays([When does the accreditation expire?]-Today())<=90,"<div style=\"background-color:yellow;width:10\">Renew</div>", ToDays([When does the accreditation expire?]-Today())>90,"<div style=\"background-color:lightgreen;width:10\">OK</div>") The rich text formula field doesn't seem to work in dynamic rule. Appreciate if someone can shine some lights on this. Thanks! ------------------------------ Joanne Wong ------------------------------ Re: If...then...conditionThanks Paul! It works! ------------------------------ Joanne Wong ------------------------------ If...then...conditionHi, I'm working on a formula which will give me the follow: If the field "When does it expire" equals to or more than 90 days from the expiration date, the field "status" will change to green with text "OK"; if it equals to or less than 90 days from the expiration date, the "status" will change to yellow with text "Renew"; if it passes the expiration date, the "status" will change to red with text "Expired". The "When does it expire" field is Date and the "Status" field is a rich text formula. Any tips on how to write this formula would be greatly appreciated!! Thank you 🙏 !!! ------------------------------ Joanne Wong ------------------------------