-
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…
-
Calendar
Hello all, I've recently added a new job to my smart sheet and it is not appearing on my calendar which I have previously synced. Do I have to sync it again or something?
-
Link to another sheet and add additional days
Hi there, I am trying to link to a master schedule but adding some additional days to define my drop dates. Please help. Thanks.
-
Fiscal Quarter not displaying properly
Hello everyone. I am trying to create a calendar by quarter. Our quarters start in Nov and end in Oct. While I have designated this in the calendar....it keeps giving me 2018/2019 instead of 2019/2020. Can someone help me figure how to get the quarters to display properly? Thank you in advance. Lisa