-
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…
-
Managing Allocation % for Many Projects
I have a task that takes me 2 hours to complete, but I have 4 business days to complete that item. So, I have a start date of 02/04/17 and a due date of 02/08/17, so the duration column automatically shows up as 4 days. If the % Allocation column defaults to 100%, in the Resource Views tool, it looks like for 4 days, I’m…
-
Collapsing rows on report
Good day, Is it possible to collapse rows on a report? Y
-
Backup - Link attachements to row ID/number
Hi, When you make a backup of a sheet with many attachments such as pictures and pdfs these will all be downloaded to one big ZIP folder. Say you have 500 rows with attachments, there is no way to link the attachment to the right row. Is it possible to automatically rename attachments as you upload them? With row number or…