-
Access list more than once
I'm in the home building business after I walk a house I make punch list for multiple subs to complete items that pertain to their trade. I have been sending "Send Update Request" to each sub. Some subs might have 10+ items.....they can't remember every item on the first time opened and would like to be able to refer back…
-
Alert based on Report, not Sheet?
Is there a way to set up an alert based on changes to a report instead of a sheet? I have a "master" sheet that constantly grows on a daily basis and several reports for different departments to display the information that is relevent to only their department. If I set up an alert for the sheet then the department leads…
-
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…
