-
Program Report
Hi There, Im trying to create a report on tasks that are programmeed to be undertaken in a specified date range (but not necccesarily starting or finising in that same date range). For example: I have a task that starts on the 1st of February and ends on the 20th February (i.e 21 days of work to complete the task) I want…
-
Send Update Request
Hello All I want to share an exciting SS discovery! I am currently doing the Smartsheet Project Management course. The send Update Request function will truly transform my work life. This option does not require the person being requested information to log into smartsheet to answer the specific questions I require…
-
Link data into a cell out of an attachment
Hi, Is it possible to get a cell auto populated from data in an attachment in the form of a PDF or Excel? Our goal is to reduce manual capturing of data that continually changes. Y
-
Report Help
I am trying to build a report that is looking at one "DATE" column and shows everything that is between 45 to 90 days from today. The trouble I am having is getting it to be dynamic rather than changing the date everyday. Is this possible? Any help is appreciated. Thanks, Jason
-
Smartsheet for Work Order System
Hi everyone, New to Smartsheet - very excited about the capabilities. Wondering if anyone out there is utilizing the system as a Work Order System? We get batch work orders from our hardware's proprietary dashboard system via email (excel). I would like to drop these into Smartsheet - using perhaps the help desk ticket…
-
Critical Path not working
The critical path on my schedule is not working, is there a report I can get from smartsheets to see what is porssibly going wrong? or Tips on what to do?? Much Appreciated! -Marisela
-
Schedule Cell Linking w/Lag
I have linked multiple project schedules together, but I'm wondering if there is a way to add lag time between the links? Currently the finish concrete completion date of the first becomes the clearing and grubbing start of the second, but I'm wanting to add a one week lag time between the two while keeping them linked.…
-
Copy and paste text from email
I have a smartsheet set up for RFI's (request for information) on a project. If somebody sends a query by email, how can i copy and paste the text from the email into the smartsheet ? I copy the text but 'paste' is greyed out when i try to put it into smartsheet ? Urgent help needed please so i can pack up for the weekend…
-
Percent Complete not adding up
I need some help figuring out how to make my "% Complete" column reflect the actual percentage using my "Hours" column and not "SLA" (days). The sample below is clearly incorrect. It should be more like 64% complete. I'm totally stumped.
-
import csv or other file into existing project
We have been working with Omni Plan and would like to import existing project management schedule files into our SmartSheet projects that have already been started. Eventually we'll do all the project schedule management ( we're a construction company) as part of the sheets but we're new at this and I don't need to stress…
