-
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…
-
Manage multiple values in a cell from a dropdown list
Good morning, I am facing an issue on my smartsheet, i have a column (dropdown list type) that allowed multiple values per cells and i am trying to manage these different values in order to concatenate them the way i want in another cell. Does anybody knows the way to pick a single value from all of them or even the way…
-
Project Progress/Reporting
I am creating an simple method to help us determine project progress to report back to our customers. The idea is to group tasks into phases and then classify each project as being in a specific phase depending on which tasks have been complete. Once all tasks in a phase have been completed, the sheet will report back that…
