-
Quarters in fiscal years formula
Hey all, I'm trying to write a formula that will return the quarter and fiscal year (FY) of a given date. Our fiscal year is October - September. So for the first quarter, the FY doesn't match the calendar year (CY). So far I've been able to execute this for one CY, but if I try and add a second CY, I get back a blank…
-
Individual Days Off
Is there a way that I can schedule individual days off and have them reflected in my Gantt charts? I know the options are available for across the board, but what about individual vacation days. Thanks!
-
Cannot open published calendar in Outlook
I am trying to publish and open a calendar in Outlook but receiving an error. I have tried clicking the link to the calendar directly in SmartSheet (Go to Calendar View on the left menu, then select Publish at the bottom, enable publishing and Get Link). And I have tried going into Outlook and adding ti manually via File,…
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
-
Vacation/Out of Office causes resource over allocation?
I hope someone can help me out here, or tell me how they approaches this :) In my department we have some issues when people are on a project and then going on vacation or out of office, it will show as if the person is 185% over allocated. (for example if it is 85% project and 100% vacation) Is there any workaround on…
-
Calendar with multiple date colum
Hello: I have prepared a Master Calendar to have all our events in one page. Nevertheless our situation is not that our dates come from different smartsheets but that the dates come from different columns in the smartsheet. Eg. Date #1, Date#2, Date#3 in one line (different columns). This is because sometimes our Xservice…
-
sum column and calculate total to hrs:min
I have a "duration" (used to track time involved) task field that I need to be sum and show on a report as hours:minutes. The column is a drop down field with numbers only in 15 min increments. example: 15 30 45 60 75 90 etc... Appreciate any replies.
-
Smartsheets for medical practices
Does anyone know if smartsheets solutions can be used to manage medical projects? This would include documenting information that would flow via api into an existing enterprise system.
-
change task color in filter calendar view
I'm sure this is very simple as I did it for one of my filters but not for the life of me can't figure it out again. Looking to change the color of my tasks in calendar view when I apply a filter. thanks Mike
-
Filtering with Start and End date views
I have filters setup to view different tasks on separate calendars. However it only shows the StartDate. Is there a way to enable EndDate as well?
