-
Days Lapsed/Column Formula
How do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it states it's not quite right to convert. Any suggestions?
-
Lookup To Return Multiple Results
Hi - I've done some research, but am struggling to find the best solution on this one. I am trying to do a lookup from one sheet to another based on a Unique ID. A VLOOKUP returns only one result, but I'd like to return all of them back to one cell in the other sheet. It seems like some combination of COLLECT, JOIN, etc.…
-
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"…
