I have a column that does a lookup from another table, if there’s no record and the cell is empty, how can I target these empty look up rows since .isBlank() doesn’t match these empty lookup columns?
as you can see conditionally formatting isn’t matching on the 4 rows above, 2 empty and 2 empty arrays(due to missing a task to pull a status from)
Lookup() returns a list of rows.
One approach might be a conditional formatting rule that’s something like this:
status.Count() < 1
ah good shout! Thank you very much for the help!