Calendar Displaying blank fields

I am trying to create a smartsheet calendar off a workplan, and am running into the following issue. I don't need all the items from the workplan to populate on the calendar. My main column is [task name], and for some rows, I have an associated [event type] in another column. I only want the calendar to populate the rows that have both a task name and event type.
I tried to workaround by creating an additional column [Calendar Task Name] that populates with the formula =if([task name]=0,"",[task name]@row).
When i pull [Calendar Task Name] into the calendar, it looks like those cells have been populated with empty text, and a blank calendar event appears. Is there a way to return a truly blank cell if the condition in the formula is not met so a blank calendar event won't populate?
Answers
-
What about creating your calendar from a Report, instead?
You can filter the rows in the Report (see here) to only be ones that are not blank in the Event Type column.
Would this work for you? If not, it may be helpful to see a screen capture of your sheet (with sensitive data blocked out).
Cheers!
Genevieve
Need more information? π | Help and Learning Center
γγγ«γ‘γ― (Konnichiwa), Hallo, Hola, Bonjour, OlΓ‘, Ciao!π | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!