LennyBrooks
3 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
------------------------------