LennyBrooks
4 years agoQrew Member
Help if Formula Rich Text
I'm trying to use an IF statement in a Formula Rich Text formula field in a report. I want a yellow triangle to populate of a certain date is or before today. Here is my formula, which seems fine until I save the report, and then I get the attached warning.
If([Collections_Lien Review Date]<=Today(),"<img src='https:\\images.quickbase.com/si/16/241-triang_yellow.png'>","")
This is the warning I get, and I'm not sure why it refers to CASE when I'm using IF.
Formula error -- Bad or missing arguments in function call
You may need to do one of the following to fix the problem:
------------------------------
Lenny Brooks
------------------------------
If([Collections_Lien Review Date]<=Today(),"<img src='https:\\images.quickbase.com/si/16/241-triang_yellow.png'>","")
This is the warning I get, and I'm not sure why it refers to CASE when I'm using IF.
Formula error -- Bad or missing arguments in function call
| The types of the arguments or the number of arguments supplied do not meet the requirements of the function Case. The function is defined to be Case ( |
You may need to do one of the following to fix the problem:
- Choose the right number and type of arguments.
- Use a type conversion function to convert the arguments you are using to the correct type.
- Choose a different function.
------------------------------
Lenny Brooks
------------------------------