Updated formula breaks Calendar Report
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
Answers
-
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.
-
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
It looks like the formula is working but is there some reason why the data stopped showing up on my report and calendar?
-
Is the report and calendar showing anything at all for the labels?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!