Cell linking
Discussion List
-
Looking for most recent dateIn Formulas and FunctionsI have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet …
-
Rich Formatting On "Summary Sheet"In Formulas and FunctionsI'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from mul…Answered - Pending Review 11 views 2 comments 0 points Most recent by GabeHarris Formulas and Functions
-
Populating a Dropdown ListIn API & DevelopersHi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
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…