Identifying location of a Column ID without a Sheet ID

StephenOKeefe

We have a custom implementation of the Bridge which is returning the following error in our Run Log:

"The value for cell in column 3928364019935108, INPUT, did not conform to the strict requirements for type CHECKBOX."

The problem is we don't know which sheet this is occurring in which is making it hard to understand what the root cause of the problem is. Is there a way to identify the location of a column without a Sheet ID? Note we have six-thousand Sheets and it's not practical to do this manually.

Genevieve P.

Hi @StephenOKeefe

The issue seems to be that this column is a Checkbox type of column, likely with the restrict option set in the Column Properties to restrict it to a Checkbox value:

But you're attempting to add a value that is not either 0 (unchecked) or 1 (checked).

To find out what sheet this column is stored in, check the Run Log. The Column ID wouldn't be available unless your Bridge Workflow accessed that specific sheet, which means that the Sheet ID should be in your Run Log. See the bottom screen capture in this article: Troubleshoot Workflows with Run Log

If you don't know the sheet name from the ID, you can use a simple Get Sheet module to input the Sheet ID and get the Sheet Name from the Run Log.

Cheers,

Genevieve