I’ve got following problem:
Zapier pushed the invoicesnumber in realtime to column A.
The invoice-number is e.g.: EC-1002, EC-1003, EC-1004 an so on.
However from time to time some invoice numbers are missing. Is there a way to recognize or highlite the missing number?
e.g. 1004 is missing here.
There is no “direct” solution, but a workaround.
This is what you can do:
- Create a formula column and convert the invoice number into a string (i.e. EC-1001 → 1001)
- Create a second new column and use the data processing operation to calculate the delta between two consecutive rows.
- Add conditional formatting to the second column and highlight all cells where value > 1
Important: This only works if the table is sorted by the invoice number.
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.