No Category Appearing on Calculated Column in Calendar App

I have a report which feeds into the calendar app in which we track speaker utilisation. The data is grouped by speaker name and then their total utilisation. When utilisation is zero, it shows this in the report but shows as No Category on the calendar. Is there anyway to change this to 0?

I've got a countif for utilisation on the sheet which feeds into the report and I'm wondering if I could incorporate a 0 before the result then this might help show no category as 00? Unsure if that would work but it's the only thing I can think of so appealing to the bigger brains!

=COUNTIFS({Speaker}, HAS(@cell, [Speaker(s) Name]@row), {HCP Paid}, (CONTAINS(@cell, "Not Applicable")))

Find more posts tagged with

Calendar App

Countif

Accepted answers

Sam McDonald

If I add a new column to my sheet and use this formula then it works great so thanks for the inspo!

=IF([2024 Total Utilisation]@row = 0, "00", COUNTIFS({Speak}, HAS(@cell, [Speaker(s) Name]@row), {HCP Paid}, (CONTAINS(@cell, "Not Applicable"))))

All comments

Denden8706

Try

=IF(VALUE(COUNTIFS({Speaker}, HAS(@cell, [Speaker(s) Name]@row), {HCP Paid}, (CONTAINS(@cell, "Not Applicable"))=0,"0", COUNTIFS({Speaker}, HAS(@cell, [Speaker(s) Name]@row), {HCP Paid}, (CONTAINS(@cell, "Not Applicable")))

Sam McDonald

Hi @Denden8706 thanks for your response. This gives me incorrect argument set when I'm hoping the results will be 00 and then this shows up instead of No Category on the calendar

Sam McDonald

If I add a new column to my sheet and use this formula then it works great so thanks for the inspo!

=IF([2024 Total Utilisation]@row = 0, "00", COUNTIFS({Speak}, HAS(@cell, [Speaker(s) Name]@row), {HCP Paid}, (CONTAINS(@cell, "Not Applicable"))))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.