-
Searching a column in another sheet
Hi, I'm trying to reference contact info from one sheet and have it show up in another as I type. I want the second sheet to search a column as I type and match the contact name if it exists. Does smartsheet have a vlookup or something that can search another column in real-time as I type. An alternative would be a drop…
-
VLOOKUP Won't Reference Another Sheet
In my 'Install' sheet status column I have a formula =IF(Health3 = "red", "At Risk", IF(Health3 = "yellow", "On Hold", IF(Health3 = "blue", "In Progress", IF(Health3 = "green", "Complete")))) In my 'tracker' sheet i am trying to reference the the status column in the 'install' sheet. =vlookup I've selected cell to…
-
How to Link my 2020 Capital Budget to my Capital Budget Form
Hello My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up as follows: 1. Is the capital expenditure request a 2020 approved capital expenditure.…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
-
Cell linking
What am I doing wrong? I am linking cells from one sheet to another. When I do so I select two cells and then link them to two cells in another sheet. However, only the first cell has a link not the adjacent one? Also when I delete the link and go to try again the deleted link still appears in the source sheet.
-
Can a Dependency outcome be set to show an early or late value in production process?
Hi There, I am using my smartsheet to manage a production of furniture goods. I have set columns up for Start/ Finish/ Expected finish/ Duration/ and Delay to Expected finish. This will enable me to see where the delays are happening in the process and analyse where to improve. I have set the dependency between the…
-
Subcontractor needs Help
We are new to smartsheet and looking for advice on the best templates to use to track schedules, and being able to track delays, etc. Would anyone be willing to share ideas or sheets that you have found useful to your business? Thank you! Sarah Link
-
Index / Match Multiple columns from another sheet
I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the team information. When I add a name to the new sheet, I assign that name to a team.…
-
Update field in another sheet
Hi there, i'm trying to figure this out: I have sheet #1 with an email address field. When that field is updated, Smartsheet automatically updates sheet #2 email address field with the email entered in sheet #1. Is this possible?
-
Cross Reference Formula: No "AVEARAGEIFS" so trying to use "AVG(COLLECT(" to use multiple criteria b
I am trying to average how many days a claim has been open for a certain technician. We signify the claim being open by having a certain column being blank... here is the current formula that I have: =AVG(COLLECT({West (Tech Sheet) Range 1}, "", {West (Tech Sheet) Range 2}, "Artur Alimov - ARAL", {West (Tech Sheet) Range…
