Updated formula breaks Calendar Report

NickEL

Good afternoon.

I have a Calendar report that is looking at 11 sheets. All sheets have two check box columns that add data to two separate Calendars in the Calendar App. I was originally using this formula:

=IF([RegOps Overlay Calendar]@row = 1, JOIN(ANCESTORS([Task Name]@row), " - ") + " - " + [Task Name]@row, "")

and everything worked as expected. Another group saw this and wanted it for their calendar. I figured that rather than create an extra column to write a similar formula I would add what I needed to the original formula. This is what I came up with.

=IFERROR(IF([RegOps Overlay Calendar]@row = 1, JOIN(ANCESTORS([Task Name]@row), " - ") + " - " + [Task Name]@row, IF([Key Stakeholder Overlap]@row = 1, JOIN(ANCESTORS([Task Name]@row), " - ") + " - " + [Task Name]@row, "")), "")

Now no data shows up on my Report or in the Calendar App. Is there some other way to write the new formula?

Thank you in advance for all of your help.

Nick

BullandKhmer

I'm a bit lazy to figure this out. But first thing I would start with is removing the IFERROR( ,"") syntax from the start and end of your formula and see what the error message is.

Probably a minor syntax error.

Paul Newcome

What column types are

[RegOps Overlay Calendar]

and

[Key Stakeholder Overlap]

Are you able to provide a screenshot of the formula actually in the sheet similar to the screenshot below?

NickEL

It looks like the formula is working but is there some reason why the data stopped showing up on my report and calendar?

Paul Newcome

Is the report and calendar showing anything at all for the labels?

NickEL

I apologize for the insanely late reply. I forget what the solution was but this issue was definitely caused by user error. @Paul Newcome I appreciate all of your help with this and my many other questions.