-
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…
-
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…