-
A formula for filtering out duplicates
Hi, I have a Production Schedule sheet that is inputted from our ERP system. I'm trying to make a report that shows all the orders not ready to go into production for the next 2 weeks. My issue is that the orders go through 2 stages and therefore have different start dates and show up as duplicates on my report. 1st stage…
-
How do I get just the first 4 characters to the left of the text string (2700-insurance)
JOIN(COLLECT([2700 & 5090 Codes]@row:[6000 Codes]@row, [2700 & 5090 Codes]@row:[6000 Codes]@row, @cell <> ""), ", ") I need to get the first 4 numbers to the Left of the text string from each of the columns and output to another column. there are 9 columns that I will be collecting from. Thanks for any help
-
Can a COUNTIF formula "count" when there are multiple values in one cell?
I've created the following formulas to count how many times a person's name is appearing in a configurable (Contact List) column for Project Lead and then Assigned To on another sheet: =COUNTIF({Project Lead}, Primary@row) =COUNTIF({Assigned To}, Primary@row) The Primary@row is directing to the name of the person I have…
-
same sheet formula references not highlighting
I can't seem to understand how or why my formula references sometime work and sometimes not. I use the simple [Column Name] and sometimes it works, sometimes not. Is there a trick to it that I am not seeing? Its easier to reference another sheet because there is a way to simply select the appropriate column. Maybe there is…
-
How can I automatically add data to the dropdown list ?
Hi all, Sometimes i need to add new data to a dropdown list but it's hard for me to add because it's in a lot of different sheets. How do i automatically add data to all dropdown list column? (Python, Automation, Make, Zapier etc.)
-
Formula to change cell based on info from another sheet?
Hi @Paul Newcome, you offered to help find a solution to a problem that was discussed in another thread if I started a new thread and tagged you... so here goes! (Thank you, by the way). I have a sheet that tracks progress through a workflow. One of the items I'd like to track is if a ID number appears on another sheet. If…
-
IF status symbol based on cell date or blank
I'm trying to write an IF formula to return a status symbol based on if a date column in my sheet is in the past OR is blank. Smartsheet keeps telling me my syntax isn't quite wrong, and I'm having trouble seeing where I've gone wrong. Here's what my formula looks like right now. =IF(ISBLANK([Expiration Date]@row), "Red",…
-
Index/Match instead Vlookup
Hi good day. I just created a formula to grab dates from another source sheet. The situation here that i created using VLOOKUP and read that it is recommendable to use Index/Match for this kind of situations. Can you help me to build the formula and including if there is #NO MATCH show in blank? Thanks in advance. Below…
-
COUNT IF, INDEX, MATCH
I have one table with a reference number, a sub-vessel number and a check box column to select the desired subvessel. I want to use a formula in another sheet to count the number of times a value is present in SOURCE(subvessel selection column), where the SOURCE(reference number) matches the TARGET(reference number) and if…
-
Capture Sheet Data Metrics by Current Year and Quarter
I am assisting our Marketing team with tracking social media statistics year over year broken out by quarter. I want to create a sheet summary field that captures metrics for the current year and a specific quarter to populate and auto-refresh on a dashboard to avoid manually modifying the metrics each quarter/year. Is…
