-
Can I Import a Large Excel Sheet with Embedded Formulas into Smartsheet?
I am needing to import an excel sheet into Smartsheet with 10+ tabs at least 16383 columns. There are imbedded formulas referencing different sheets in the excel. Is there a way to go about this rather than importing one of the tabs at a time, and manually rewriting a lot of the formulas?
-
Is there a way to create a flow chart that leads to a result depending on how the user answers?
Hi! I currently work in a manufacturing plant where in order to quote a new project we need to create a chart showing the number of people and the line speed required to run the project. I am currently the only one on my team that has the knowledge to make these, but would love to create a flow chart type system where…
-
Join formula started adding a leading zero on text from certain columns
I created this formula, and it worked great the first two times it was used. The third time, it added a leading 0, which is NOT present in the [Circulation Requirement Details 3] column. I did further testing triggering the function using [Circulation Requirement Details 4] and [Circulation Requirement Details 5], and 0 is…
-
Record the time when specified criteria are met
Hello, I'm new to Smartsheet and I want to set up a workflow that records the date and time automatically when a previous column's value is changed to "Yes". I know there's a template for recording a date when specified criteria are met, but I couldn't edit it/find one to automatically record time. I see that there was a…
-
Unparseable for multiple IF statements
Hi, I'm trying to use multiple IF formulas within one cell by transferring from the Excel sheet I created it in, but I keep receiving the "#UNPARSEABLE" error code. Here is the formula I've attempted in SS: =IF([Support Intensity]@row="high", 9),IF([Support Intensity]@row="medium", 6),IF([Support Intensity]@row="low", 3)
-
Hyperlink for mailto: in Reports, Dashboards and Grids
I've seen this topic come up a few times now, but couldn't find an enhancement request submitted. It would be nice to have the ability to link email addresses in Reports, Dashboards and Grids. The dynamic contacts in Smartsheet is a nice feature turning email addresses to a standard First/Last Name, but could we add the…
-
Identify MAX Date for each employee
I have created a list that tracks the number of days an employee is out. I need to identify the most recent absence. An employee can be on the list more than once. I would like to use the MAX function to identify the most recent absence for each employee by checking the box in Max Date. Is there a way to do that? The…
-
COUNTIFS Function with an "Or" function included?
Hi all. I am currently trying to create a COUNTIF function that has 2 required parameters, and then 4 "or" parameters. Basically, the formula should count if the RAID Log box is checked AND if the RAID Item is Risk. Then, it should count if the item's status is "new" OR "in progress" OR "deferred" OR "ready for close".…
-
IFERROR Function Struggles
I have a working formula that I need to add an IFERROR function to so that the cell is blank when there are no values to satisfy the formula instead of receiving an #INCORRECT ARGUEMENT SET response. Here is the working formula without the IFERROR: =MEDIAN(COLLECT({Resi - PC2 Testing Duration}, {Resi - Enter Stage 7 Date},…
-
Alphabetize Using Formula
Is there a way to easily alphabetize a list using a formula in smartsheet? In Excel, I would use the simple formula shown below to assign a numerical value to each unique list item. =COUNTIF([Unsorted Range],"<="&[Specific Cell Value]) This formula doesn't work in smartsheet, so I'm trying to find a solution. I am working…
