-
Sort not working for Editors?
There is probably a easy explanation or fix for this but I can't figure it out. I have a sheet with about 10 editors that as things move on the sheet it needs to be resorted (sorted by a due date). For some reason I am the only one that can sort the sheet, the Sort option is greyed out on all of thier sheets - I've…
-
RYG Balls average
hello, i am looking to find a way to do an average with the RYG balls. ex: 2 green, 2 yellow, 2 red should have should show yellow ball for the overall project. is this something possible? thanks for your help
-
If then statements with date fields
Hello. I am trying to calculate a date field based on the following manually entered data: * If "Project status" is not "Cancelled" [drop down field] * And "Const duration" is not null [text/number field] * Then add "Const duration" to "Start date" to equal "Completion date" * For example: * Start date is 6/21/18 &…
-
Editing an email sent from a row
I was wondering if there is a way to have someone edit a field when you just send a row to someone. What I mean by this is would be the person receiving the email able to check completed or update a date from just the email rather than sending someone an update request?
-
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…