Support
Discussion List
-
Trying to fix the start date of a subtask with no dependencyIn Using SmartsheetI trying hard code the start of a sub-task (4th level indent). When I try the start dates always comes back to the start date of the task of the previous indent. I would like to have my sub-task with no dependency to start much later (har…
-
Is there a way to create a search box?In Formulas and FunctionsWe are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
-
Array formulasIn Formulas and FunctionsHi, I was looking for using array formula functionality in smart sheet. I need this because i saw that like this i can full fill what i need. Any case, could you please mention if is a way to use array or other solutions in order to per…
-
Forms with formulasIn Formulas and FunctionsI'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back th…
-
Days Lapsed/Column FormulaIn Formulas and FunctionsHow 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 s…
-
Lookup To Return Multiple ResultsIn Formulas and FunctionsHi - 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…Answered - Pending Review 28 views 7 comments 0 points Most recent by Genevieve P Formulas and Functions
-
How do i track progress based on output?In Formulas and FunctionsI 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 spreadshee…Answered - Pending Review 12 views 1 comment 0 points Most recent by Sam Harwart Formulas and Functions
-
I will send you $100 USD if you can help me solve thisIn Using SmartsheetHi 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 deal…
-
If function for children rowsIn Formulas and FunctionsHi 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 …
-
Getting StartedIn Using SmartsheetDoes 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 t…
