-
Cross Sheet Joining Automation
Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox that initiates a purchase request next to each item. My initial stab at this is when…
-
Can you append sheets in Smartsheet like you can power query in excel/power bi
Hi I want to append/consolidate sheets in smartsheet in a master file or separate sheet all the sheets are the same but for different locations im using forms to collate the info because the forms are site specific I want to combine the two sheets below as example in a master sheet and at the same time the master will…
-
Automatic Finish date and Finish time columns for a 3D Printer Sheet
Hello everyone, I am creating a sheet for my 3D Printer and I need some help as I am new in Smartsheet and in using functions. I want to make the "Finish Date" and "Finish Time" automatic, meaning once I input the Start date, start time and duration, the Finish date and finish time will automatically show when my 3d print…
-
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.
