-
Copy a certain columns to a new sheet as new rows are submitted
I have a master sheet that contains information submitted via a form. I am wanting to have a new sheet that contains only certain columns of information that populate as the data on the master sheet is entered. I only need specific columns of information, not every column in the row on the master sheet. Any ideas on how to…
-
Contact type column across multiple sheets
I have a list of contractors that is constantly being updated, from when they are on-boarded, to when they are deactivated. I would like them to be entered as a contact type column. I have multiple sheets where I want this column to be identicle, and also want that when I update Sheet A and add a new contractor and their…
-
Join Collect with text
Join Collect is a new one for me and I am struggling... I am wanting to JOIN COLLECT with results only with BFF PM, listing the contact name/card Master sheet: Current formula: =JOIN(COLLECT({Area Contact Range 2}, {Market Area}, [Market Area]@row, {Title}, "BFF PM"), " , ") Reference:
-
Configuring multiple sheets to all update each other in datamesh
Hello there, I am trying to configure datamesh to work between a parent sheet and its children. I have a master sheet with like information, and an automation that copies rows to child sheets (which all contain the like information and additional information based off of departments) and am trying to link the like…
-
Cross Project Dependencies
Hi SmartSheet Community! I have built a portfolio of projects and I want to create an additional project within the portfolio to capture action items that need to be completed before some of the tasks in the related projects could complete. Example, I'm making ice cream and I have three projects in the portfolio: Vanilla…
-
Linking Two Sheets to update dynamically When columns are added and removed.
I have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were to add in a row between two and three with a value of 2.5, I would like this to update on…
-
Date format - Cell linking
Hi, When I try to cell link a date column it changed the date format from: dd/mm/yy to mm/dd/yy. The strangest thing is that it did not happen most of the rows, but some random ones. I have tried to refresh the sheet several times, but I still get the same date errors. Do anyone have any idea or suggestions in order to fix…
-
Sender Field = linked in from cell
It would be even better if we could have the sender be a link in a cell. For example, I would like the email to appear it's coming from one of our Coaches as opposed to the Company.
-
Can't compare two string values
So I'm using this formula to try and compare two "String" values. In this situation, some values in Column 2/3 will be numerical only and some will have text. I have a helper column checking that both are string values but it still won't match. I've tried with collect and contains too. I'm trying to pull the value in…
