-
Linking Errors
Hi When I link out from my smartsheet to individual schedules it does not show the link anymore until I refresh and then it crashes. I get this error - see screenshot
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
How to show last passed child on parent row?
I have been trying different ways to show last passed "gate" of a project. The project can have from none to few child rows. There is a column with passed gates as tick marks. Now I want to show the last passed gate text side by the parent row. I haven't figured out how to do this automatically. Any help is welcome!
-
How to calculate resolution time?
I have a sheet, where via form the Project team submits a Change Request. I need to calculate how long it takes the submit the request until it's marked Approved. We are trying to calculate the resolution time So I have a column called " date of creation" and I have another called "Last review". which will make it easier…
-
Linking Construction Program line items to relevant task lists
I'm working for a design and construct fit out company and we're looking to invest in control center and I'm just looking at the configuration of the project workspaces and need some ideas for the following scenario.... Each project has a construction programme which is shared with the client. Within that program there are…
-
How to make a "Tasks by Status" Widget on Dashboard
Anyone have a clue how to make this Tasks by Status Widget on a Dashboard? Is this made using a report or is it just a widget? My goal is to list how many Tasks are on a report that are green, yellow, and red in the same exact format shown. Thank you!
-
How do I add a contact to a report that’s pulling select tasks from multiple project schedules?
Newer user here!! What’s the best method to pull a contact (PM Assigned To) from an intake sheet into a report that’s already pulling select tasks (Materials) from multiple project schedules? I'd like to be able to show the project manager, as well as sort by PM, for the project on a materials report; which is a list of…
-
Auto generate project number using formula
Hi, I'm trying to create a formula that will auto populate the project number when a new project is created through a form. When a project is added through a form it appears at the top of the sheet. Our project numbering system is YY-XXX where YY is the year of the start date of the project and XXX is the project number…
-
Resource Allocation – Multiple Task owners in one Task
Hi, How can I allocate the resources in single task when I have multiple task owners or multiple Task managers? * How can i allocate the hours based on individual manager? Best Regards Saqib
-
Count Date + N/A
I have a columns "LAN M Actual Complete" and another column "2nd Touch Indicator" I need total Site complete: count if "LAN M Actual Complete" has a date and "N/A" in the "2nd Touch Indicator column" Dont' count if "LAN M Actual Complete" has a date or no date and "2nd Touch Indicator" is blank or something else besides…