-
Change task Duration based on a condition in another cell
Hello Everyone. The projects I handle are the same each time in terms of the tasks to carry out. but they can differ in duration based on the 'size' of the work... I am using a standard sheet template which I also use to forecast, I would like to change the 'duration' of a set of tasks based on a dropdown that would return…
-
Is there a way to re-designate the primary column after a Smartsheet has been developed and populate
I would like to switch the information that is displayed in the calendar view to data that is present in another column within my sheet.
-
Reports - restrict date range
Hi, Is there a way to restrict the date range on reports with the gantt view? i.e. I only want to see the next 3 months, next 9 months etc. Thanks!
-
If updates are made to one smartsheet, can it be ported to another?
I have two smart sheets that are almost identical(one is a copy of the other - except I removed 3 columns). I am looking for a functionality such that if updates are made to one, the second smartsheet gets updated automatically! The reason for two smartsheets and updates is because the audience for both the files is…
-
Creating an automatic Change Order
I was wondering if there is a way to create a change order in a smartsheet so we do not have the type everything out and it will auto populate pricing?
-
Task not scheduling properly
I have a plan in a smartsheet which isn't scheduling as expected. several task that have no predecessor seem to be staying put. I'd expect them to move to the project start date. I can find no option to change constraint type. I've exported it to MS Project and it exhibits the same behaviour until I review the Resource…
-
Row changes that don't affect Modified Date field
I see in your help documentation that changes to discussions and attachments do not affect the Modified Date type of System Column. Is there a reason for this? If a week-long discussion takes place within the discussion feature of a row, the Modified Date element makes it seem at first glance as if the toipic has not been…
-
Construction Calender
Hey Everyone, I'm trying to build a Job Calendar. I've input the dates and split it up into Man Days and Man Weeks. My dilemma is this: I need to be able to select a range of dates (ie Jan 1-8) so we can see our expense for that specific week. I've searched everywhere and cannot figure this out. Any help or suggestions…
-
Anyone having issues with Outllok app uploading attachments that are NOT checkmarked?
I submitted an email to support yesterday but have not heard back. I'm having an issue where I uncheck attachments I do not want to upload to SS and it's ignored and uploaded anyway. I then go into SS and delete those attachments. For a lengthy email chain, there could be a lot of jpg's from signatures that do not need to…
-
Help automating sharing
I was wondering if there was any way to automate sharing when planning schedules. I have a sheet that has multiple tasks on it, however I only want to share it to the people I assign said tasks to. Rather than having to assign the task and then having to share the sheet individually to every person on the assigned column…