-
How can I link two sheets together?
Hi. I am a communications and brand manager, and I have two sheets that I will be working from primarily. One is a Request Form, the other is a Master Calendar. These need to be different because the Master Calendar includes things such as company events to which I need to send a photographer for internal communications,…
-
How can I make my calendar reflect the color of a data selection?
Hi! I am making a calendar that will include multiple locations that will then be put on our company webpage so all global employees can see what is going on at any other location. People from different offices will be able to fill out the form and it will auto update on the webpage. I have a dropdown with the different…
-
Calendar display summary tasks
I have Display Summary Tasks checked in calendar settings. Issue is that only some of the summary tasks are displayed (in Gray), but not all. How do I get all to display? They seem to be setup exactly the same.
-
New Taskbar Color for New Project
Hello All, I recently having been building up smartsheet for our agency and I had a questions about the taskbar colors. Right now I have a template that will be used for all new projects. The taskbar defaults to the light blue color. When coworkers use this template, I'd like the default color to be randomized so all…
-
Is there a way to share/publish a calendar view with only the calendar part minus the top and side..
Is there a way to share/publish a calendar view with only the calendar part minus the top and side tool bars.. I want to show only the parts within the red box. i dont want the viewers to change the calendar to grid or filter stuff..
-
Creating Project Timeline Visualizations-Not Gantt View
I am wondering if anyone has experience with creating a high-level project timeline view to put on a dashboard--and I am not talking about a Gantt view. What I am trying to do is avoid my customer from having to continue producing PowerPoint slides manually of the data they are managing in Smartsheet. Ideally, they would…
-
Extract Date from Modified Date
I am trying to use the Modified Date column in formulas. For some reason, it doesn't appear that this was created as a "Date" column type. Because of this, it cannot be used in any formulas that would allow a date. Is this assessment correct? Also, is there a way of pulling the date out? I've pulled out the Month, Day, and…
-
Parent Row Only Report
Is there a way to build a report consisting of only parent row information? I am trying to show overarching HR Processes in my sheet (parent row) without pulling in the sub-tasks. I tried a checkbox report but the sub-tasks are still showing up in the report although they were not selected. Perhaps there is a workaround or…
-
Is there a way to edit the Details Panel Layout for Calendar App entries?
I have text fields where the text extends the size the of the box, thus, not showing all information to shared users when they view the details of calendar entries. Similar to how one is able to determine what fields are shown (and how) in the Details Panel Layout for entries in the Dynamic View app, is there a way to have…
-
Calendar Invite Automation
Is there a way to send automated calendar invites to something like Google calendar (preferred)?
