-
How can I copy information to a new sheet to create a log?
I'm trying to see if there's a way to have data copied from a few specific columns to a new sheet. I'm hoping to create a log for IT issues as they occur on requests. The difficulty is setting some sort of trigger that will move the information over into a new row whenever a new issue is added. The other possibility, would…
-
How to convert a number with a fraction reading as text, to a number (3 2/3) to 3.66
I'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 function. Thanks in advance
-
Automatic Workflow for multiple rows
Hi 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 are 3 rows with materials and delivery dates column ( 2 column just ) . I created a…
-
Unable to Edit 1 Column on a Spreadsheet
Hello 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 spreadsheet is currently some 40-50 columns wide, but for some unknown reason I am unable…
-
if formula help
I am trying to do a formula that states: if there is text in the column2 then place a "1" in the primary column. @Paul Newcome
-
How to pull rows from a different sheet only if they're marked as "in progress" ?
Hi 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 cell. Is there a way to do this? Thanks in advance!
-
Is there a limit per sheet on the amount of cells that formulas are applied?
Hello, 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?
-
Help us design API classes that meet your needs
Hi, 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?
-
Return Multiple Rows Using VLOOKUP and COLLECT
Good 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 "BA Edit" in sheet B. I have tried doing this several ways, with no success.…
-
Drop Downs
I'm using multiple dropdown columns on my smartsheet, most work, but a couple don't. When I try to click on the dropdown, nothing happens. Not sure why?
