Cell linking
Discussion List
-
INDEX and MATCH across two sheets: a detailed explanationIn Best PracticeHello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to…
-
Formula to add "No" to a blank cell, but leave value if not blankIn Formulas and FunctionsOn a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank. Auditors do not like Blank cells, so I'm looking fo…
-
Calculate the time between two dates by days, hours and minutesIn Formulas and FunctionsHi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
-
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…
-
INDEX/MATCH function doesn't return exact match.In Formulas and FunctionsI'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting f…Answered - Pending Review 23 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Pulling Multiple Rows of Data into 1 CellIn Using SmartsheetHello, Does anyone know how to pull multiple rows of data into one cell? I'd like to build a cell that look-up the date "05/20/20" and brings all the values into one cell. I'm thinking vlookup: =VLOOKUP("5/20/20", {Te…
-
Bring Task to a separated Smartsheet if due dateIn Formulas and FunctionsHi, I have several tasks Smartsheet's to manage different projects. In order to avoid keep checking each Smartsheet for due dates, I would like to have a "Summary" Smartsheet that brings only tasks that are about to get due. How …Answered - Pending Review 11 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Column Formula QuestionIn Formulas and FunctionsIs it possible to convert a cell formula to a column formula if it references a different sheet? Here is the formula in question: =VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false) Where [Project Name] is a column in th…Answered - Pending Review 24 views 1 comment 0 points Most recent by Jason Duryea Formulas and Functions
-
Auto fill a second column based on a drop down selection using a formIn Formulas and FunctionsI understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one op…
-
Can I create a report/Sheet that would capture all conversations on multiple sheets in a workspace?In Using SmartsheetI have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?
