-
Count if Expiration Date is in the next 3, 14, 30 Days without counting Past Expiration Dates
My Formula is "=COUNTIF({Expiration Date}, <TODAY(3))" switching out the number for the appropriate timeframe. When I do a filter on the sheet it is referencing to there is only 1 expiring in the next 3 days however the formula keeps giving me an answer of 2. I am unsure if it is counting the 2 that are past the expiration…
-
How to pull data from another sheet based on a specific criteria
Hello, I have one sheet that includes all of our projects listed in rows and I need to create specific sheets outlining the tasks for each of the rows. The new sheet should also include specific data (such as dates, names, etc.) from the first sheet. I'd like to be able to link data from specific cells from that first…
-
Formula for separating names
Hello all i have a smart sheet that was imported from excel and need help. Currently I only have the full name in one cell (i.e) John doe. I want to have it where it will split the first and last name into the next two cells in the same row. And then I need it to take either the full name or the two separated names and…
-
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",…
