Cell linking
Discussion List
-
Indirect style look up from another sheetIn Using SmartsheetHello, I am trying to access data from another sheet using a reference to another column within the row using a sum formula usually in excel I would create a =indirect() reference, how could I replicate something like that within smartshee…
-
Is there a work around for trying to use CONTAINS() or HAS() within collect()?In Formulas and FunctionsI am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a multi select column (I have also tri…
-
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…Answered - Pending Review 34 views 2 comments 0 points Most recent by Ashley356 Formulas and Functions
-
TimestampingIn Formulas and FunctionsHello. Is there currently anyway to do timestamping in Smartsheets? For instance, timestamping a cell when a tick box cell is ticked? Thanks Andrew
-
TimeStamp Formula ValueIn Using SmartsheetHi, I would like to get a time/stamp value from a form entry onto to my master sheet , and have it reference the name of the person who made the entry. So for example, if I place an entry on the form, I need for my master sheet to match …
-
Is there a way to easily/quickly hyperlink 100's of sheets.In Formulas and FunctionsI am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink and go directly to that person's individu…Answered - Pending Review 19 views 3 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Sorting & Filtering Linked Cells From Source SheetIn Using SmartsheetI am unable to figure out how to sort and filter linked cells from the source sheet. I have a sheet with cell links which needs to be sorted or filtered when the source sheet is sorted or filtered. I am unable to use a report or dashboard…
-
Drop down list from another sheetIn Formulas and FunctionsI currently have two sheets. Sheet1: Company List, Sheet2: Contacts. I am trying to create a dropdown column listing the companies from Sheet1 to populate the drop down for a column in Sheet2. This would essentially work as a lookup to …
-
Help with Trend DataIn Formulas and FunctionsI need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. …
-
Cross Project DependenciesIn Using SmartsheetHi SmartSheet Community! I have built a portfolio of projects and I want to create an additional project within the portfolio to capture action items that need to be completed before some of the tasks in the related projects could complete…
