-
How to count the times a person is assigned to a defect status
Objective: Have dashboard that reflects defect status and who is assigned to it, if blank then "Not Assigned" Example 1 Jake has three defects assigned to him. 2 = "Intake" 1 = "Vendor In Process" Example 2 Eric has 5 assigned to him 1 = "Resolved"; 3 = "Ready for Retest"; 1 = "In Process"; For any defects not assigned,…
-
Automatic Linear Percentage Complete Formula
Hello, I am wondering if you can help. I currently use Smartsheet for project planning. I would like to build an automatic percentage complete formula. This formula should work off a linear progression line from Actual Start Date to Baseline Finish Date and the duration. So an example of a task would be: Actual Start: Now…
-
Smartsheet count function
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?
-
VLOOKUP with IF and IFERROR Formula
I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull in Survey Status “Complete”, otherwise (IFERROR) "N/A". This is the new formula I…
-
How do I make a Smartsheet that keeps track of initials
I'm trying to make a Smartsheet that keeps track of how many times a set of initials appear on a column. I have a Smartsheet now that people can put there initials on when they complete a task but I would like to be able to track how many times people completed certain tasks.
-
Remove a dropdown option , if it is already selected
Surprised, this does not exist yet in smartsheet. I am creating a sheet , All I want to do is once a timeslot has been selected by a customer, the timeslot should no longer appear in the dropdown or hide it or make it un selectable. I am happy to explore the automation workflow option too, but there is no way to configure…
-
Enable Datalink from other Smartsheet for Dropdown list (for Multi and Single Selection)
Dear Sir/Madam, Kindly request you to add or enable datalink option in Dropdown list which helpful smartsheet users to update the Dropdown data in one place and utilize it all dropdown list. Thanks for prompt support. Best regards.
-
Send alert to task's assignee when predecessor task's status changes to complete
Hi all. New, enthusiastic user here hoping for some guidance. In setting up a repeating process, I have dependencies/predecessors clearly identified. Wonderful! Now, how does one set an alert/notification to auto-send to a task's assignee when the task's predecessor's status changes to "Complete"?
-
Turn Cell Formula into Column Formula
Hello everyone! I am at the beginning of making some operations sheets for my job and will need to rely on column formulas I have successfully input a formula in a cell and it works! When I drag the formula down, it works. However, when I try to convert it to a column formula I get the error saying that the syntax is not…
-
JIRA Sync To Smartsheets Not Syncing
The Problem: JIRA is actually not auto syncing like it should to pull in tickets automatically into smartsheets Notice: The workflow is set correctly to sync JIRA fields to smartsheets The Problem: We have to go into this workflow manually, edit it, then let it run every day. This is NOT automatic syncing like its intended…
