-
when adding a new event to construction spreadsheet start date will not change
i have add some rows to a certain stage in the construction process, however with each new event i add the start date always goes back to the construction start date no matter if i change it on the calendar function or type the date in please help i am using a gantt chart to plot this project out
-
% Complete column can only be updated manually?
Is it true that a % Complete column for a gantt chart can only be updated manually? It would be beautiful if I could use a formula which would update it automatically.
-
Dependency Settings
i am trying to build a construction timeline for a project. and i need to use different dependency time frames for different vendors in the same spreadsheet. for example: Permitting works on a business work week schedule. so Mon-Fri no weekends and no holidays. However the GC has agreed he wiil complete his work in exactly…
-
Smart sheet as CRM
Hi there, We are in the process of a new enterprise, and really love using Smartsheet, especially the history function. I’m looking for a good CRM cloud software, were I can easily manage contacts, pipeline, promotions, billing, INV, inventory etc. I think Smartsheet is perfect for pipeline management, but I miss the…
-
Recuring events
Hi there, Is there a way to schedule recuring events in the timeline without having to insert new individual tasks? This would be for recuring site meetings etc. Thanks Annina
-
Formula Imbalance
I know I've missed something basic here. =SUM([Contract Amt]1:[S- AWO $]1:[CL AWO $]1)-([Material Allowance]1:[Sub Allowance]1)/[Total FB Hours]) Thanks for help!!
-
Send alerts to two people using the same column?
I have set up a smartsheet where by the 'assigned to' is alerted by email when a task is due. However sometimes the 'assigned to' needs to be more than one person therfore i have to amend my columns to be 'assigned to 1' and 'assigned to 2' to ensure both people get an email alert when the taks assigned to them is due.…
-
How can I get Calendar view info to wrap so it can display more than 20 characters?
I want to be able to show more than the 20-25 characters limited in the display of a calendar entry. e.g., I need to be able to show an "Issue No. (10 characters) + an Impact" which can be a list of multiple things. I would not mind if it wraps around into a second row as long as it displays all the information needed by…
-
Creating a customer Work Order form.
Good day! We are looking to change our current system of work orders (creating it manually on a hard copy) to doing it via Smartsheet. There doesn't appear to be a template already in existence. Has anyone ever created one? One of our primary concerns is how do we get a customer to authorize the work? Thanks Rob
-
Star Ratings/ Symbols - changing amount?
Hi, I have a sheet where we want to monitor the value of a project simply with a 1 to 3 star rating, but the only star symbols available are either an on/off, 1 star symbol, or a 0-5 star rating. Is there any way of reducing the mount of stars to simply 1-3, or is there a formula (similar to the RYG ball) to show this? I…