No Category Appearing on Calculated Column in Calendar App

Options

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")))

Best Answer

  • Sam McDonald
    Answer ✓
    Options

    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"))))

Answers

  • Denden8706
    Options

    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
    edited 06/06/24
    Options

    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
    Answer ✓
    Options

    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"))))