Sheets
Discussion List
-
How to create an Index Match Formula for multiple sheets?In Formulas and FunctionsHi, I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information. The destination sheet has two columns that it will look at. A "TIDC"…
-
Index Match Across Multiple SheetsIn Formulas and FunctionsHi Everyone, Hoping y'all can help as I'm at a complete loss. I'm trying to pull information into 1 master sheet based on a unique identifier across multiple sheets and it's just not working. I can get it to work for 1 sheet using =INDEX(…
-
How can I use VLOOKUP to find data from multiple sheets and combine it in another sheet?In Formulas and FunctionsI have an existing database of suppliers/vendors set up in a sheet, and I'd like to automatically show if they're currently working on a project and which project they're currently working on, as well as the dates they're working on the pr…
-
Rows ReorderedIn Using SmartsheetOur sheet is used as a chronological order of events. Often when others are working in the same sheet, everything gets set out of order. I know Smartsheets does not support autosorting outside of reports. However, it would help if I und…
-
Merge 2 column names from separate sheets into one in a single reportIn Using SmartsheetHi I want to create a single report that can be circulated on an email that pulls data from 2 separate sheets. In some cases I've been able to align the column headings, for example "Assigned To" is common across both sheets. H…
-
Automatically move rows within a single sheetIn Using SmartsheetI pulled a template for a Team Productivity Hub (https://app.smartsheet.com/b/publish?EQBCT=f29e0f2c058f4563853d6497ce554bcc) from the solution center and the sheet for tasks had originally moved completed tasks to the "completed"…
-
Need help with seeing if a cell contains the quote symbol.In Formulas and FunctionsI want to locate " in a cell but Smartsheet wont allow me to run the following: =IF(CONTAINS(" " ",[Column]@row),1,0) Is there some sort of symbol that will allow me to reference this in the quotations of the formu…
-
AND statement in smart sheetIn Using SmartsheetI am having issues getting results back when using AND statement I am trying to compare two conditions, and show if an action is late or not using the following formula I want to say if the End date is before today and the completed is b…
-
Trigger IssueIn Using SmartsheetFor one of my sheets, when someone submits a request through a form, I have some rules that assign approvers, and also some rules that assign the number of approvers. These always work fine. Okay, as one example, let’s suppose the number o…
-
Assigning an auto-numberIn Using SmartsheetHi I have a sheet that is populated via a form and if questions are answered in a certain way it copies cells to another sheet. Once the row has been copied to a the other sheet I have other update workflows that are triggered. The problem…