Cell linking
Discussion List
-
Crossing multiple data bases with a Partial Text/Number matchIn Formulas and FunctionsHello all! This is my first question. I am building a tracker called "My Project Tracker" that takes information from multiple "master sheets" built by different teams with different purposes. See screenshot for example…
-
Latest Comment in CellIn Using SmartsheetIs it possible to reference the latest comment on a row, in a cell? And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opp…
-
Track inventory movement in multiple warehouse locationsIn Formulas and FunctionsHi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, War…
-
Formula to match two column inputs within one row in two separate Smartsheet's.In Formulas and FunctionsRoster Smartsheet: Course Email Eval Completed Class1 [email protected] =formula here Class1 [email protected] =formula here Class2 [email protected] =formula here Eval…
-
Formula help - reference data from 2nd sheet, with conditionsIn Formulas and FunctionsHi, I’m looking for help with a formula for my sheet. Images of my sheets are below Goal: I want to auto-populate the Holiday column in Sheet 1 with data from Sheet 2, based on certain conditions. Populate Sheet 1 Holiday column with da…
-
COUNTIFS between dates & criteria.In Formulas and FunctionsGreetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: …
-
Is there an easier way to automate multiple columns from a single multi-select dropdown?In Formulas and FunctionsOne of my teams uses a sheet to track to the status of products in every state, with a column containing a status dropdown list for each state (Requested, In Progress, On Hold, Completed, etc.). We recently implemented a form for our inter…Answered - Pending Review 22 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Connect several columns from data sheet to another sheetIn Using SmartsheetI have searched all over for this and have seen several references to VLOOKUP and INDEX/MATCH. From what I have been able to gather is those functions are using some type of extra reference to work. I have a large data sheet with a lot of …
-
How do I set up a workflow to notify someone if a predecessor task has been completed?In Using SmartsheetI am currently trying to develop a project plan sheet, and I am wanting to be able to notify someone when the predecessor task was completed so they know they can start working. For example if John has to do a Data Source Identification a…
-
VLOOKUP on the if false of another VLOOKUPIn Formulas and FunctionsI have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID&quo…