Skip to content
TROUBLESHOOTING

Publish Not Working

Summary

Diagnose cases where a U.PUBLISH formula does not produce a usable report for subscribers.

Symptoms

  • U.PUBLISH returns an error or an unchanged value.
  • Subscribers do not receive the expected report.
  • A report appears in one environment but not another.

Likely Causes

  • Report group, report name, metadata, or environment do not resolve to the same topic.
  • The publish formula is blocked, skipped, or publishing reserved metadata through the wrong method.
  • The data range is empty or contains only errors.

Step-by-Step Diagnosis

1. Verify Topic Identity

What to check: The publisher and receiver resolve the same report address.

How to check: Compare the visible report group, report name, and environment cells or use U.TOPIC.

Expected result: Both sides resolve to the same topic.

2. Check Publish Return

What to check: Whether the publish formula is blocked, skipped, or returning an error.

How to check: Inspect the cell containing U.PUBLISH and the metadata cells it references.

Expected result: The formula returns a recent numeric timestamp-like value rather than an error or skipped message.

3. Check Source Range

What to check: The published data range is non-empty and not entirely error values.

How to check: Inspect the exact range passed as report_data.

Expected result: At least one cell contains valid report data.

Resolution

Correct the topic inputs first, then remove unsupported metadata from the standard publish path or switch to the specific method indicated by the error message.