Cell linking
Discussion List
-
Numerical "Priority" MethodIn Formulas and FunctionsHello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column …
-
Auto populate data in FormsIn Using SmartsheetI am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS Firs…
-
CONTAINS with Trigger SearchIn Formulas and FunctionsHi all, Thank you in advance for the help. Below is what I am trying to achieve. The columns are as follows: Address and Device Type Explanation: When Device Type contains the word "Coin". This will use the address of the device …Answered - Pending Review 14 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
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: …
-
Populating a Dropdown ListIn API & DevelopersHi, is it possible to populate the contents of a dropdown list from another smartsheet?