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 resolu…
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 fol…
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,…
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…
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. O…
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
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" …
Hello! A thing we really need in our company is a way for managed users in Resource Management to still get notification if they are overallocated across project plans in Smartsheet. Because even thou…
I am building a personal task tracker template for my team so everyone can better manage daily tasks as well ass see any tasks assigned to them as part of a project. Is there a formula or way to have …
Good morning. I am running the Jira Integration, and I would like to create a view or report that lists linked issues (in the 3rd column from the screenshot) as child rows. The text will always be in …