I want to build a conditional formatting formula based on the first two letters in a field. I haven’t been able to get a formula to work. For example, I have a field that has data like, R-N-1, R-S-4, R-C-5, ST-2, ST-5, ST-GP etc. I want to be able to format all the rows that start with “ST” in this field. I also want to create another conditional format with the rows that start with “R”.
Is there a wildcard that works in Coda or a way to query begins with?
Any help would be appreciated.