Hi can someone help please. I am trying to create a format rule that needs to add an icon when there is a value in a specific column but also another column must be blank. I cannot seem to get an expression right for this. So if “Status” column says Visited and “Visited” column is blank the icon must be added.
Please try an expression something like below in the format rule condition
AND([Status]=“Visited”,ISBLANK([Visited]))
Thank you
User | Count |
---|---|
38 | |
27 | |
23 | |
23 | |
13 |