-
Highlighting Duplicates in a Database?
Hello there, I am creating a customer management software with thousands of companies. I'd like to highlight all duplicate entries under the "Company" column (See image below). In an ideal world, both entries for the company "Effective Spend" would be highlighted since it is a duplicate. Is anyone able to share how this…
-
Add point values and weights to answers
I have a Smartsheet form that is populating answers from the individuals who fill out the form. I'd like to do the following three things with the various answers: add point values to answer choices add “weights” to different questions run calculations on a series of questions. For example, if the person put an answer that…
-
Returning data from another sheet matching on two criteria
I am trying to create a report which brings back the actual performance for performance measures for the last month, 2 months ago and three months ago. But am stumped as to how i can do a lookup to the base data sheet using two criteria (MeasureID and where the date is last month etc.) The base data sheet has a row per…
-
VLOOKUP Incorrect Argument
This should be simple but I can't get it to work - help appreciated. Simply trying to bring a column of data to another sheet. Both columns are set to text and I keep getting an error message =VLOOKUP({M&E Themes Range 3}) Cheers
-
Calculating number of years between dates
I have tried a few of the formulas I found in the community to calculate the number of years of service for our team members, but I keep getting an Invalid Operation message. Here is the formula I tired and a shot of the columns I am working with. What am I missing? =IF(Date@row > [Count Date]@row, YEAR(Date@row) -…
-
Linking on Only Current Month Data
Hi everyone. I am hoping you can help me. I have rows of data by month with column titles. I need to have a row that only shows the current months information. I have researched the community and found an index with children formula but it does not seem to be working. I have pasted the formula below I pasted in the first…
-
Counting by date
Hello, I have a sheet that counts sick calls for our colleagues. Currently I am utilizing a basic formula to count the number for said person, =COUNTIFS({WMS Name}, =[WMS ID]@row, {Absent Type}, ="SICK") This works for the initial- total count. But once they have surpassed the first threshold (5) a meeting will be held,…
-
IF / OR Formula issue
I have a ticket tracker that I need and IF, OR formula to determine if either field has a Yes. My formula works, but will only show Yes if BOTH of the other fields are Yes. I need it to say Yes if either of them are Yes. =IF(OR([Started MRR less than $500?]@row = "Yes", [MRR Change less than $300?]@row = "Yes"), "Yes",…
-
Without using Project settings/working days, (If date is a holiday, then.....) formula
This isn't working for me. I have holidays for the next two years in (Date Observed), then I have a series of dates for task or project due dates that can't be due on a holiday. I have this so far and it doesn't work: =if(or(Date@row=[Date Observed]4,,Date@row=[Date Observed]5,Date@row=[Date Observed]6,,Date@row=[Date…
-
Join collect with other sheet
I'm trying to use the best formula that will basically say.. If Distributor Name (sheet one) = Distributor Name (sheet 2), then input contacts (sheet 2) into contacts (sheet 1). There are multiple contacts on separate rows for each distributor on sheet 2 that I want to combine in a single cell for each distributor on…