-
Publish sheet in multiple views?
I'd like to show a sheet in the dashboard in both: 1. Grid view 2. Calendar view WHen I publish the link to put on the dashboard, it only one or the other. Please tell me there's a way to publish in multiple formats!
-
Best way to export a Dashboard?
Print view looks terrible, especially when we have an embedded Calendar view widget it shows up blank. We have widgets: - Report - Shortcut link to sheet - Calendar view We would like to "back up" the dashboard view to PDF or image format and attach it for those that want to view offline (and back up in Dropbox).
-
Help with Auto-populating dates
Hi All, I have been trying to figure out how to auto-populate dates. I've figured out that if I enter a date, type in the desired duration of when I'd like the task due, it populates the due date for me. All of that seems like it's project in the future and I'm running into this particular problem. Let's say I need to…
-
Workload over Calendar Duration
I am very new to Smartsheets and am in process of educating myself on the product to help develop some staffing workload tools on a project basis over time. The goal is to help us analyze how employees are allocated on a project over a calender timeline. For example, we use project milestone deadlines to break up a project…
-
Google Calendar
Hello! I am new to smartsheet...learning as I go. I have published my sheet to my calendar, and I have overlayed my calendar to my sheet, however my appointments on my google calendar that is NOT sheet related (ie. speaking engagements, meetings and conferences) is not overlayed onto my smartsheet. My sheet is utilized as…
-
Reports Exportable to Outlook Calendars?
Hi there, Are customized reports able to be published to Outlook 2013? Thank you!
-
Dates Formula (IF?)
Dear, I need help I need a formula that activates a status dependent on a date. I mean, it automatically gets the corresponding color if a few days have passed after sending a quote. Example, if 3 days have elapsed since the date the quote was sent, the status should be automatically set to Yellow And if 5 days have passed…
-
auto completion date
Hello, fairly new to Smartsheet and I have a question. We have a sheet for PO requests and one of the columns is for "Status" , it has several options from a drop down menu. What I would like is for our "Completion Date" column to automatically show the date when a status is changed to "Complete". I don't care about any…
-
Report on Resource Utilization on a Single Day
I have a project plan that was created by importing a plan from Project. I would like to create a report that shows the resources and their utilization on a single day. The only filter I see in the Report Builder is to filter on the Start Date or the End Date of a task. I want to see anyone who has tasks that occur on a…
-
Creating a calendar that is populated by dates on other sheets
Good day, Right now, we have several events happening in different cities on different days. For each event, we have a separate smart sheet, with individual planning tasks. but we want to have a combined calendar with just the dates of the actual event. I thought that I could do this by linking to the specific cell with…
