Forum Discussion
Mass error handling
What I would suggest is following -
1. Let's say the column which is having errors is called Data.
2. In a custom column, put following
=try [Data]
3. Now, it will create a column having records
4. Expand this column - This will create 2 columns - HasError and Error
HasError - True / False - You can filter on True to focus only on Error rows
Error - Will contain a record
5. Now, expand this Error record which will give all required information
What I would suggest is following -
1. Let's say the column which is having errors is called Data.
2. In a custom column, put following
=try [Data]
3. Now, it will create a column having records
4. Expand this column - This will create 2 columns - HasError and Error
HasError - True / False - You can filter on True to focus only on Error rows
Error - Will contain a record
5. Now, expand this Error record which will give all required information
Beautiful!! Thank you so much!