I have one table it has 4 columns , first column has all the table names second one is null values and third column is not null values. I want to display led gauge based on some condition . see below is my table ..
condition for led :
if($Table='Table1', count(Table1.Name)>=2 and wildmatch(Table1.address,'Delhi','bangalore'),green(),
if($Table='Table2' , count(Table2.Name)>=5 and match(Table2.Pin,'123','456'),green(),red())))
how to write multiple if condition to show color for LED column? Give me your ideas ,solutions .
Deepak, did Tim's post help you get things working as you wished? If so, be sure to come back and use the Accept as Solution button on his post to give him credit and let others know that did work. If you are still working on things, please leave an update for us.
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.