-
Collect Multiple Row Data into a Single Cell Reference
Hi Smartsheet Community, I am attempting to create a meeting planning set of sheets, and I am struggling with the following. SITUATION: Provide a formula for referencing a stakeholder register sheet for the name of a meeting attendee, and display their PTO in the cell. Please note that there will be multiple attendees for…
-
Cross Reference and Multiple Columns
Hello Smartsheets! Trying to find a solution when matching rows across sheets. Is it possible to say, if multiple criteria in columns match criteria in multiple columns on another sheet to check a box? For example, if I have identical rows on two sheets (sheet A and sheet B) of matching information, check a box on sheet A.…
-
Is there a way to see if my sheet is being referenced?
I have a sheet I would like to delete but I want to make sure it is not being referenced or being pulled into a dashboard. Can I do that?
-
Automate Linked Cells
I have an issue that I've seen in other discussions but I have not been able to figure it out for my situation. I want to automate the process of linking cells from one smartsheet to others. I will provide as much information as possible below. - We have a master sheet, "Project Dashboard" with about 15 columns where I…
-
There has to be an easier way...
Hi smarties, I have 40 metric sheets (one per location). In each sheet I have an countif formula that references a data sheet. I have this formula in about 20 columns. A sample is in the screen shot. It says something like count if the name in the Frontline leader column of the metric sheet matches the name in the data…
-
Count the number of occurances of text strings
I have 2 Smartsheets. Sheet 1 contains the data. Sheet 2 is a helper that I use to drive a dashboard. In sheet 1 I have course names. I don't want to have to explicitly code for each course as new courses may be added. In sheet 2, I want to return a value that is the course name in one column and in the next column return…
-
Sumifs w/ cross sheet references not working
Hello, I have a customer list and I am trying to use it to extract data from another sheet to get customer specific information. My SUMIFS formula to total the $$ for all projects with a specific customer is working. =SUMIFS({BidBoard Quoted Value}, {BidBoard Customers Bidding}, HAS(@cell, Customer@row)) But when try to…
-
=AVG(COLLECT Formula Referencing Another Sheet
Hello! So I have a master sheet copied into 2 other sheets where people will make updates to in several row sections. I want the master sheet to reflect the averages of what they select in each row section (in percentages) into the master sheet's identical section (sorry if that does not make much sense, not sure how else…
-
IF with HAS and Multiple Choice dropdown.
This is a complicated one so bear with me. We have an form users fill out and one of the questions on the form is multiple choice where they can select more than one answer. There are 3 correct answers to this and fourth option that is incorrect. We've been asked to give to give them "10 points" if they get all 3 correct,…
-
How to show 5 different sets of checkboxes in same column?
Hi, I'm putting together a slightly complex master sheet for Dynamic View. It needs to show something like 5 different sets of checkboxes in the same column. I'm thinking I can achieve this either by creating 5 sheets, each showing the individual checkboxes OR a single sheet with the various sets of info in individual…