Highlight Row based on Multipule Choice Field
New to Quickbase. Looking to highlight a row based on the status drop down. I have the multiple choice drop down but cant figure out how to get it to highlight the row based on what is chosen.
Forum Discussion
i don't see that option
- Are you saying that you don't see
Color-code rows using a formula
at the bottom of a table report configuration screen? - where is the table report configuration screen?
- Have you build a report? If so, just "Customize this report" at the top right when viewing the report.
If you have not built a report, then go to Reports and Charts and create a new report of type Table. - Got it. Now have this error.
The types of the arguments or the number of arguments supplied do not meet the requirements of the function Contains.
The function is defined to be Contains (Text u, Text v). - My IF has the brackets in the incorrect place.
In future please post your code when you have a syntax error.
IF(
Contains($MultiTextFormat, "apples"), "red",
Contains($MultiTextFormat, "bananas"), "yellow",
Contains($MultiTextFormat, "apricots"), "orange")
