I am using smart containers with google sheets as the datasource.
I would like to map one column of data to be used purely as reference data to drive conditional formatting.
I don't want this mapping data to be visible. I thought I could use white colour text as a way of hiding it. I can't seem to get this to work.
Any suggestions?