-
Formula to return the SUM of prices from a cell with multiple values (multiselect column)
Hello! I'm sure someone has encountered this issue before so hopefully there's a work around it. We have a tracker with multiple service requests. We document each request in a very detailed way here. We already have a lot of columns here, so adding more than 2-3 is not an option. From a multi-select column named…
-
Why are most of my months showing up "N/A" when I know there is data?
Why are my metrics showing N/A on mostly all of my months for Long Term Project TCC? Please see formula below Populates only one month:
-
IF/And/Join/Collect
Hi Smartsheets community, I am trying to create a summary field in a sheet that joins all the text from one column that meets these criteria: has a created date less than 20 days old has a label of "decision" in another column OR a star for priority in another column. I have a sheet used to track RAID entries, and…
-
"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!