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
2 Likes
ah good shout! Thank you very much for the help! 
2 Likes