Hey Guys, I started to use the JIRA connector for Smartsheet and run into some basic issues while creating the workflow. Idea here is I want to create the Jira tickets (Epic, Story, Sub-tasks, Bugs) f…
All My project team members want to have "look ahead " insight into tasks they have upcoming. Is there a way to notify the assignee of the successor task when the predecessor is 75% complete, or x num…
I have many projects in a Project Management workspace. The project sheets have a section to order materials for projects. I have a GRID Sheet in another section of Smartsheets that creates purchase o…
I am new to smartsheets and I am having a hard time with a formula, hopefully someone can help me. I am trying to create a formula that will indicate the status of a task based on the following condit…
I have created a "Master Sheet" that I have to import each day and have linked up other tabs/sheet to that Master Sheet to filter out on the information my technicians need to see. On the Master Sheet…
Hello, I want to use the AVGW function to get the weighted average of the column "Cost" against the column "Probability of Cost" but only if the column "Status" is Approved. The column "Status" can al…
Hi fellow Smartsheeteers, I encounter another challenging scenario that some of you have encountered and find a solution to it. Here is the scenario: I have task as an individual and also have task as…
Hi, Can anyone share how they're tracking their teams resources? The resource allocation is great however, it only allows me to show one team member not multiple per task. In addition, I'd need this i…
