-
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a…
-
Notifications and update requests
I'm automating the update request and reminder stages to update my activities. The worksheet is not shared, but I've enabled the alert permissions for the least restrictive. The actions and alerts indicator column appears in the reminder symbol and is in pending status, but is not sending email to the requested contact.…
-
[SmartSheet-Jira] Few basic workflow queries
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) from Smartsheet but need 2-way sync to keep updated everything on both the places. Query 1: during the workflow setup, I…
-
Notification of Assignee when predecessor is 75% complete
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 number of days from completion. Currently they receive the notification the day the task is to start. Any suggestions are…
-
Configure Form
* How to configure the selection of two or more options within a single question.
-
Shortcut button of sorts for a Project template
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 order numbers and has a brief description of materials ordered. I would like a shortcut on each project sheet that would…
-
Nested IF/AND formula
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 condition: * whether the task is completed or action is required * whether the task is at risk or not To conclude this is what I…
-
Toolbar Inconsistencies
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 I have the full options on the toolbar, but on the linked tabs/sheet there are hardly any options. For example, my…
-
Conditional Weighted Averages
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 also be Pending. The function SUMIFS works great if you don't need to do the weighted average. Is there a preset function or…
-
How Smartsheet define, handle and monitor allocation on teammember
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 a team member. Example of task that involves team are doc reviews with a group of people. I have numerous scenarios: 1)…
