-
Formula to change status symbol if a task is not completed before due date
Thanks guys, new to Smartsheet and need some help... Having issues with changing the status symbol to Red, Yellow, Green, or Gray based on project completion percentage column (%Complete) and start/due date columns ("Start Date" / "End Date"). I would like the following: Gray - If %Complete equals to 0 and start date has…
-
Task duration as a function of the number of resources
Hello! Can task duration be calculated as a function of the number of resources? If one person takes three weeks then allocating three people should complete the task in one week, etc. This should be easy but I can't find this capability. I'd appreciate suggestions on how to do this. Thank you, Michael
-
Is there a way to update source sheets for multiple reports?
We created about 30 reports. Each of them is taking the data from multiple sheets (each sheet is a project that our team is working on.). When we add a new sheet (new project), we have to go through each report one at a time and add the new sheet to the source data in the report template. This is very time-consuming when…
-
Add date to formula
Hi I am currently using this formula =SUMIFS([Number of Slides]:[Number of Slides], Done:Done, 0, Status:Status, "Handed to Pathologist") I want to look at the date for the next 30 days. I have a column titled "Due Date" with dates (2/20/2021) in them. I want the total number of slides in the next 30 days. Could you please…
-
Manpower Projections w/ Multiple Schedules
I have several projects and we are inserting the schedules into Smartsheet and linking those with various sheets. One thing I would like to create is a sheet that pulls in Crew Size from each job and for each date range display the labor needed. In each schedule, I placed a column for estimated hours and then used a…
-
Generic timeline on Gantt chart
I'm trying to put together a Gantt chart with a generic timeline (i.e., Month 1, Month 2; Week 1, Week 2, etc.) rather than actual dates. Is there any way to do this in Smartsheet?
-
Options to show multiple project plan sheets into one view
I currently have a project where I have project plan sheet for each country. I'd rather keep them separate than combining into a single sheet, however I'd like to show the combined details in Gnatt view and checking for date overlaps. Has anyone tried to do this before?
-
Template recommendations for tracking product design approvals and status from design to production?
So I've been looking at Smartsheet as a solution to a project tracking problem, but I'm having a hard time finding a template for the purposes I'm intending it for. If this needs to be created from scratch, I'd love to be pointed in the direction of some resources. I work at a company where we have many products being…
-
Return Multiple Rows Using VLOOKUP and COLLECT
Good morning, I am working on a formula which will return multiple rows of data from a different sheet based on criteria. For context, I am looking to view all the cells from sheet A (defined in a range) where there is a value like "BA Edit" in sheet B. I have tried doing this several ways, with no success.…
-
Request for advice on best way to structure sheet column fields / data for reporting
Please give me your input on the best way to structure my sheet data to achieve the reporting/summary options desired. The current data is being migrated from an Excel workbook with ~20-30 column fields per row which makes it difficult to use for our project management/collaboration. But Thus far using the construction…
