JoanneWong
Qrew Member
Joined 6 years ago
User Profile
User Widgets
Contributions
Dynamic rule setting for rich text field
Hi 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 ------------------------------12Views0likes8CommentsIf...then...condition
Hi, 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 ------------------------------7Views0likes2Comments