-
"INVALID DATA" Error
I've written out this formula numerous ways at this point and I think I'm just trying to work outside of my current abilities. I'm trying to write an "IF" formula to calculate the cost of shipping materials because there are 4 different scenarios that I need to calculate for: Scenario 1: No shipping material used ($0).…
-
Formula Help: How to exclude past dates with MIN formula?
I am not good with formulas and haven't been able to figure this one out with usual troubleshooting... I am using the following formula to return the next upcoming Review Date (screenshots of use below). =MIN([Next Review Date]27:[Next Review Date]30) But I want to make it so that it doesn't include dates that are in the…
-
Formula to check star symbol question- Need Help!
Hi friends, I need a smartsheet formula to check a star if any of the date columns are within the next 90 days AND if any of the text column values contain "text - value" in them. I have been using generative AI to assist me but something is slightly off an I keep getting an invalid operation error. below is the formula:…
-
Getting a #Date Expected error using NETWORKDAYS and TODAY()
I have a simple formula to calculate the number of days between a date and today. But getting an error. Any ideas?
-
Show how many weeks a status has stayed the same?
Asking this question again in case there are any more ideas - I have a sheet where a weekly status update is logged every week on a new row, including the Health "trend" (Up, Down, Sideways). I want to count the number of weeks that the trend has stayed the same, i.e., how long it has been sideways/up/down. The only…
-
Running total cost
I am trying to utilize a sheet for cost tracking. I have a column where the dollar amounts are being put in, how can I just have the value of the column to keep a running total?
-
Convert to Column Formula = Specific Word
Hello, I want to make a column automatically populate a text word (i.e. CMHA) using Covert to Column Formula. I have done this in the past with a number but cannot remember and keep getting an error. I would appreciate your help!
-
How would I get my VLOOKUP to return multiple Values?
Is there a way to get my VLOOKUP to return multiple values? Current Formula: =IF(ISBLANK([(REC) - Project Number]@row), "Part Number", IFERROR(VLOOKUP([(REC) - Project Number]@row, {QC1}, 3, false), "Part Number")) In my example image, there are 5 Project Numbers with unique Dates / Part Numbers / Part Descriptions / PO…
-
Need help with a formula to sum all numbers in a column that have the same date?
Hi there -- I'm working on a project where I need to track the total number of hours a person worked each day. A person may have three rows (log entries) with the same date, so I'd like the formula to count the hours column for each row that has the same date. In the example above, the Total column would show the total…
-
True/False IF formula not working?
I noticed that the formula I was using wasn't working so I moved it to a text column to see if the output is correct. Turns out the output is giving me 0, so no wonder the checkbox isn't checking! My issue is that I'm trying to get a checkbox to check if the values are either -5 or 5. However, I'm stumped on what I'm…