-
Smartsheet Merge and Transpose
Hello, I have two sheets. One sheet is a list of items to be offered at a charity auction with a different row for each item and columns with specific (Item number, donor, minimum bid, winning bidder number, cost etc). The 2nd sheet is a list of the bidders with a sum of the total that they have bid (bidder number, count…
-
Linking Sheets
Due to the 200 column limit in a sheet, I have had to split my data into multiple sheets, using the project name as the Primary Column for each sheet. I know how to links cells and use IF formula to pull the Project Name column data, but I cannot for the life of me figure out how to automate it, where if I add a project…
-
Multiple Links to Another Sheet
Hello. I have several sub sheets that feed into a master sheet. In the master, all the tasks and columns of the sub sheets appear. We're having vendors update the sub sheets, and when they do this, their inputs are linked to our internal master sheet. What I want to do is EASILY set up multiple (and numerous) cell links…
-
email lookup
hi, Is there a way that if I choose a name from a drop down box in one column it will show the appropriate email address in another column? regards, Mark
-
Pulling data from one sheet to another
Hello: In Sheet 1, I have Column A that lists courses to be developed in the next term. There are several rows, but not every row contains a course. Row 1---BUS 123 Row 2---CUL 232 Row 3--- Row 4---DSH 343 Row 5---ENT 111 Row 6--- Row 7--- Row 8---HSM 399 In Sheet 2, I would like to include the list of courses from Sheet 1…
-
Using Excel as primary data source
I've been reading about the Live Data Connector feature in Smartsheet, but it doesn't sound as though it will solve my dilemma. I have a situation where highly confidential data in an Excel worksheet cannot (per policy) be stored in the cloud. However, not all of the data in the worksheet is highly confidential, and I…
-
count if formula help
Was hoping to get some tips on the following use case. I set up a Smartsheet to track all my organization's training accreditations. This includes (student, assigned coach, product course, accreditation level, status, etc.). I want to create a formula that counts the number of open engagements per coach. This will help me…
-
Lock a Field
I have a field with a formula in it and I want to be able to lock it so only owners and admins can edit. i cant lock the row as details have to be changed by editors in other fields in the row.
-
Cell linking from Report?
Hi all, I have a question and/or suggestion regarding cell linking. I have a master sheet that needs to pull cell links from multiple sheets which have very specific parameters. The sheets that we are pulling the cell links from all contain vast amounts of data, so we've created a report to pull the specific data that we…
-
Automatic Cell data input..Formula???
I am polling permission via web form from 150 of our top accounts. The web form will only collect client info they would know, such as their name, account name, email, contact # and yes or no for permission. However, on our end, when that entry comes in, I need other internal info to auto populate based off the "Account…
