-
Can I create a If Then statement using a date in smart sheet?
I am trying to get a summary of duration for a particular resource within a particular month in smartsheet. This is unfortunately so that I can then input the hours into a custom ERP that lacks any intuitiveness. How could I do this? Here is an example Resource . Duration . Start Dates, End Dates LD 2 days . 8/29 8/30 AD 1…
-
Showing a task duration in the Calendar View
Does anyone know how to show a task duration in the Calendar view? I can only see the task on the date it starts and I would like to see an extended bar for the task that goes from start date to end date. I'm a Smartsheet beginner and would appreciate any assistance!
-
Is there a way of putting a Vertical line on the calendar in Gantt View
I have created a project sheet with milestone however I want to have a line on the Gantt view that goes from top to bottom on a particular date any ideas?
-
Calendar View in Insights?
Can anyone tell me if there is a way to include a report that is using the calendar view in Sights? When I add my report, it only shows the Task Table view and not the Calendar view. Appreciate any thoughts or suggestions. Thx!
-
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…
