-
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
-
Expired Date code
So i recently create a new Cell called " Expired Date" what I'm trying to do in this cell is to show when a date has been expired , based on the Promised Date, but i found that if i left mi code just like this, But =IF([Promised Date]4 > TODAY(0), "Expired date", "-" i don't have a restriction. And i try this code, but i…
-
Resource Report View
Wondering if there is a way to create a resource view that is more of a traditional calendar view?
