-
How do i track progress based on output?
I have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadsheet, but would like to have it as part of my smartsheet plan. Am new to smartsheet!…
-
I will send you $100 USD if you can help me solve this
Hi there, If you can help me solve this, I will send you $100 USD via Paypal. My company generates leads for car dealerships across Canada. We will be using Smartsheet for our dealer partners to manage the leads we assign them. Each dealership will have their own sheet which their sales people will have access to (as well…
-
If function for children rows
Hi all, I don't know how to build a formula for the following: I want the parent row to show ''Pass'' when ''Pass'' is filled in for ALL children rows. If one or more of the children rows has ''Fail'' or ''Suspend'', I want the parent row to show ''Fail''. The children rows refer to the children rows of the parent cell.…
-
Getting Started
Does anyone know how to contact Smartsheet directly, I am on a trial version, I have sent numerous email requests, customer support forms etc. with no response. Is this normally how smart sheet runs? Should I look for different providers to support my project management Thanks Ben
-
Subtask Summary not Updating in Card View?
In Card View, my Subtask checkboxes do not tally at the bottom of the card (Full View, closed card). This is a new development. Any thoughts to help? Thanks!
-
Summing totals with 2 variables
I am trying to sum the amount of time it takes a specific individual to complete a certain task. I am trying to determine the best formula to use to accomplish this. I have been using SUMIF but not sure how to get it to work with two variables My worksheet has 3 columns: Name, Task, Minutes I need to identify the person…
-
Help with Metric sheet
Hello, I created this metric sheet to get totals for overall performance but I can't get the totals to populate from the sheet that is being referenced. Not sure what I am doing wrong,
-
How to make % frequency chart in dashboard (reasons for QC failure)
Hi, I am trying to make a chart in my dashboard that displays the reasons for QC failure as a percentage of overall frequency. The input is from a sheet with a column as shown below. You can select the mode of failure from a dropdown menu, and can select multiple items if there are multiple modes of failure. "In Dashboard"…
-
Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will…
-
Inventory Status: Reordered (How do I do it?)
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying…
