Cell linking
Discussion List
-
List one sheet to another when column contains textIn Formulas and FunctionsHi Smartsheet Guru's I have a sheet with many columns and formulas - which is increasing in size and slowing down. I would like to offboard some of the formulas to another sheet. Therefore, I would like to create a formula that looks in c…
-
Is there a way to create a search box?In Formulas and FunctionsWe are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
-
Days Lapsed/Column FormulaIn Formulas and FunctionsHow do I create a Column Formula that will calculate how many days have lapsed since the "Issue Start Date"? I currently have the formula: =SUM(TODAY() - [Issue Start Date]1) but when I try to convert it to a Column Formula, it s…
-
How do i track progress based on output?In Formulas and FunctionsI have a project that involves building fences in a number of locations. Each location has a budgeted lineal distance of fencing, and we will need to track progress of distance completed against budgeted. I can do it in an excel spreadshee…Answered - Pending Review 12 views 1 comment 0 points Most recent by Sam Harwart Formulas and Functions
-
VLOOKUP Doesn't Appear To Work With Auto-Number Columns/CellsIn Formulas and FunctionsI have a main sheet containing a list of projects with the first column containing the ID of the project which is configured as an auto-number column. I am working on setting up another sheet to track projects tasks and want to be able to …Answered - Pending Review 53 views 4 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
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 …
-
SUM cells with formulas not workingIn Formulas and FunctionsHello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the sec…
-
Using COUNTIF only if it qualifies...In Formulas and FunctionsI am trying to create a status report for items started. I think I have the formula for how many assigned, but now I need to identify of those assigned to 1 person, how many are started by that person. I tried =COUNTIF({Course Started}, …
-
Count how many jobs start in a monthIn Formulas and FunctionsI am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="…
-
Is there a way for a form in one sheet to populates a column in a different sheet?In Using SmartsheetI am looking to create a sheet that tracks who has viewed the monthly update videos on our company site. Ideally I would create a form that modifies the row, but I've read this is not possible. My idea for a work around is to create a shee…Answered - Pending Review 24 views 2 comments 0 points Most recent by Matthew Emrich Using Smartsheet
