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?
Help Article Resources
Check out the Formula Handbook template!