-
Index and Match between sheets providing Invalid value
Hi All, I have a master data sheet collating uniform info + delivery addresses. All fields work but for some reason half of delivery details come as #INVALID VALUE - Not sure what is the issue or how to resolve. =INDEX({Uniform site master Range 1}, MATCH([Site SIN number]@row, {Site Details Range 2}, 0))
-
How to get the latest submission from a form entry using INDEX/MATCH
I am trying to bring across the latest submission from a pre start form to a main master sheet with up to date information. Currently i am using the formula =INDEX({Pre Start Check current hours}, MATCH([Rego/ EC]@row, {Pre Start Check Rego/ EC}, 0)) It brings across the information but doesn't update to the latest info as…
-
Single source of truth from two sheets of shared data
I've been tasked with creating a workflow or function that lets Company 1 add rows (sales leads) containing simple client / salesperson data, and status of the lead. Company 2 would then access a sheet with this same client data, but only be required to change some drop-downs / text related to status. I started with two…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
Formulas in Automations
Is it possible to create an automation that will populate a cell with a formula instead of text or a drop down value? I am trying to get a column to populate with the name of a user who checked a box. For the action block of the automation, I selected Change Cell Value in Column to =([Modified By])@row The automation…
-
Get a list value from another sheet
Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
-
I want to stop updating all instances of cross-sheet reference
Hello, I am working on a table and am using a countif formula that references another sheet. I then want to copy paste this same formula across a few more cells but would like to change the reference column for each new cell. However, when I change the reference column on one cell, it then updates all instances using the…
-
How do I fix cell links from breaking after adding a new template sheet in Control Center?
We have a blueprint set up that has a summary section with cell links in our template sheets to navigate between the other template sheets/dashboard for our provisioned projects. We also have project metadata sheets that hold data we want to show in the summary sections. I recently had to create a new template sheet to…
-
Linking Cells with Date Restricted Format
I discovered last week that linking cells between sheets does not work if the cell being linked to is restricted to a date. Smartsheet technical help confirmed that this cannot be done. I'm not sure why this is the case, but this seems like important basic functionality, and from a user standpoint, I see no reason why we…
-
How do I move certain values from one sheet to a different sheet?
My attempt: Step 1: Sheet #1 get populated with new values (via a form submission(s)) Step 2: When Sheet #1 has a new value/row, only certain columns get populated into Sheet #2(i.e. ID number, case name, details) I tried the automation feature, but the whole row gets copied. I want it so that only certain…