IssueTracker

Hello and thanks for your feature request.

If I understand correctly you are asking for something like a custom error category that will throw an error in the UI but not in the logs. Is that right?

I am not sure this is feasible because spreadsheet functions are intentionally limited. For instance, they don't have access to the UI of sheets like scripts do.

Workaround ideas

• If returning a text string is not viable because it is not clear that its an error, could you not implement a conditional formatting rule to turn the cell red?
• Implement the calculation as a script which will summarize the errors in a sidebar UI. You can trigger this with an onEdit trigger or a time based trigger.
• If you need extensive UI customization, web apps could be an option for you.

Information required to continue

Bearing this in mind, to fully understand and complete your feature request, can you address a few points:

• Please provide some context for this request. Why do you need this functionality? What business impact does it have for you?
• Please provide an example of the spreadsheet you are using which demonstrates the workflow you are trying to implement.
• You can filter the logs, please justify why this is not suitable. In what way are you working with the logs?
• You can implement this functionality as a script that has access to the UI, again please justify why this option is not suitable.
• Why is returning a text string is not a viable workaround?

Thank you