-
Need help creating a formula that will remove a certain string of text.
My use case is: I need to remove everything within the parentheses and including the parentheses. Is this possible? I just need the name. I feel like the Replace, substitute or mid formula would put me in the right area but not able to figure it out. Ex: John Doe (123456789)
-
Formula SumiF
Hello. When I use the sumif between different Smartsheet and de column is formula the result not calculated but when put the value the formula sumif is ok. like attached. WHAT IS THE BEST FORMULA ABOUT THIS CASE? SumIf between two Smartsheet's, but both columns to search use formulas don't use absolute value between…
-
Unable to use formula based date column in gantt/timeline
Any workarounds welcome. I'm importing some task data using Data Shuttle. The task data includes Created Date, Start Date, End Date. We want to use a column formula to set the start date (if its empty) to equal the Created Date. Easy enough.. I renamed the incoming Start Date column and added a new Start Date date column,…
-
COUNTIFS multiple references to another sheet
This formula gives me an error #INCORRECT ARGUMENT =COUNTIFS({Total Lot Status Global-AgingInventoryDays}, <>"", {Total Lot Status Global-New Division}, "West", {Total Lot Status Global-SalesStatus}, "Spec") If I isolate each range and criterion under a simple, COUNTIF formula, then all three criterions work fine. It's…
-
I need collect to compare my criterion (@row data) with my criterion range (a referenced column)?
I've been working around collecting data from multiple sheets with help from this community, and I've run into another snag. I'm trying to pull data from a referenced column with a matching location name @row. It seems like a simple problem, but I keep getting #INCORRECT ARGUMENT SET. =COLLECT({2024 All Projects}, {2024…
-
Multiple Criteria
I am working on pulling information using a countifs =COUNTIFS({020-Contracts - In Queue Range 1}, "Agency Wide", {020-Contracts - In Queue Range 3}, "Requested") Here in lies my issue, for the range 3, I want it to only count if its any of these: 1-Requested 2-Assigned 3-In Progress 4-Approvals Requested 5-Obtaining…
-
Calculate a date based on the status of another column drop down
Hi, I thought I was getting closer to figuring this one out but hit a wall! I have one column that has a dropdown menu. When one of two choices is selected, I want to calcuate a due date based upon the date a report was finalized. I'm adding a screenshot so hopefully this makes more sense. So when Initial Evaluation…
-
How do I join specific cells from multiple sheets?
The question seems simpler than the outcome I'm hoping for. I need to combine distinct project types from multiple columns on multiple sheets. I know I need to use Join, Collect, Distinct, and potentially others, but I'm struggling with making it work the way I want it to. This is what I have: This sheet will be duplicated…
-
Mixed Fraction Formula
I am trying to get a cell to read 12 3/4 as 12.75 so Smartsheet will complete the math for the sheet in another cell.
-
Adding Days to a Date derived from a formula
Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the number 14 added at the end of the line. Both columns are set to Date Types. The Submission Date is derived from a formula -…
