-
Milestone task child in a % complete parent roll up
I have a number of milestones (0 duration lines) in my projects. These represent decisions, meetings, inspections and deliveries. I also use % complete to communicate with our finance department, customers and project team members. These factors don't seem to play well with each other in the schedules I have set up so far.…
-
Hello Everyone,
I would appreciate some assistance in finding the most appropriate excel spreed sheet template to track all my purchases throughout the day. Thank you!
-
How do I create a condition when a specific drop down item is selected that an email is sent ?
Using a moble app, VSI (vehicle safety inspection) I would like the ability to have an email sent to my Fleet group that alerts them when certain drop down items are selected. For example, if there are issues with the brakes and they select "Problem, Requires Attention" or when they have an expired registration or…
-
Attachments - Group Download / Report / Collective
Hello Community, We have a sheet containing a lot of attachments (photos) which we would like to collectively generate into a report, even at the bottom of the report. Is this achievable? If so, can it refer to the row it is attached? The report we generate makes no reference to there even being attachments to refer to.…
-
External Resource Allocation
I use Smartsheet for Construction Scheduling and I think it would be amazing to have resource allocation for external parties or equipment. We need to be able to set up a project schedule that can allocate a certain number of workers on a job site to each task and then be able to forecast when a superintendent should be…
-
I want to utilise an IF THEN function in Smart sheet
My example is to select a cost rate based on the employee title. If [cell1]="welder" then [cell2]=80, if [cell1]="crane operator"then [cell2]=100, etc, etc.
-
calendar view
My project management has a sheet for scheduled work. We have a color associated with each job according to who the technician is do it. Is there a way to add patterns to the lines as well to determine who is managing the job too?
-
Download files from webform?
We would like to have a webform that essentially worked like a standard 'terms and condition' agreement, where the user would enter their details, agree to the terms, nad then be able to download a file(s). The webform then creates a register of anyone that has downloaded that file. Is this possible using , Smartsheet or…
-
Sales Pipeline Sheet information links to Project management sheet upon status change
Our company tracks sales opportunities and basic project management using Google Sheets. We would like to move this function to Smartsheets. Our basic process: (We design, fabricate and install elevator interiors) A new sales opportunity is logged into a googel sheet and given a status of "Bidding". We also input several…
-
Multiple dropdown list driven by previous choices
How would you set up a dropdown list that is driven by the selection in a previous list. Example: column one has ten property's to choose from, column two is a list of locations specific to the property that was chosen in column one. Chosing a different property in column one changes the list to choose from in column two.…