functionality
Discussion List
-
How to convert a number with a fraction reading as text, to a number (3 2/3) to 3.66In Formulas and FunctionsI'm having an issue with incoming data being read as a text. I need it changed to read as a number so I can incorporate formulas. I've tried a few value formulas. The initial formula to pull the numbers from the original text is substitute…
-
Automatic Workflow for multiple rowsIn Formulas and FunctionsHi there , I would like to learn that , when we crreate an automatic workflow system taking action based on one row , i want that at the same time system will take action for all the rows with one alert. For example imagine that , there ar…
-
Unable to Edit 1 Column on a SpreadsheetIn Using SmartsheetHello all, I am working on a collaborative spreadsheet on which I am an administrator. All I am trying to do update a vlookup function for one column, which references a different spreadsheet, on which I am also an administrator. The spre…
-
if formula helpIn Formulas and FunctionsI am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul NewcomeAnswered - Pending Review 17 views 4 comments 0 points Most recent by Mike Wilday Formulas and Functions
-
IF(CHILDREN()) ? - Child inherits parent traits for entire columnIn Formulas and FunctionsI could've sworn I'd seen this but now I can't find it: We have a sheet for incoming project requests. Our general population can request multiple new mkt materials (printed direct mail, email, outlook MSG, etc.) for a campaign in a single…Answered - Pending Review 16 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
How to pull rows from a different sheet only if they're marked as "in progress" ?In Formulas and FunctionsHi there, I'm looking for a way to pull rows from another sheet if they are marked as "in progress" (or any other status that's not "complete"). Ideally, I'd want to pull everything from that row and not just a single c…Answered - Pending Review 23 views 7 comments 0 points Most recent by Marina Han Formulas and Functions
-
Is there a limit per sheet on the amount of cells that formulas are applied?In Using SmartsheetHello, Is there a limit per sheet on the amount of cells that formulas are applied? I know there are other limits, like cell linking and the amount of rows on a sheet (5000). But as far as formulas?
-
Announcement
Help us design API classes that meet your needsIn API & DevelopersHi, We are preparing new courses related to our Smartsheet API, would you take few minutes to let us know what would you like us to offer by submitting this survey: https://tinyurl.com/ycg7arps? -
Populate DropdownIn Using SmartsheetIs it possible to populate a dropdown field with values from a column in a sheet using a formula? thanks! Adam
-
Return Multiple Rows Using VLOOKUP and COLLECTIn Formulas and FunctionsGood morning, I am working on a formula which will return multiple rows of data from a different sheet based on criteria. For context, I am looking to view all the cells from sheet A (defined in a range) where there is a value like "…Answered - Pending Review 74 views 14 comments 0 points Most recent by Adam Rosenzweig Formulas and Functions
