-
Multi Nested IF/AND Formula
Hello, I really thought I could start out simple with this one and then build on it but I can't even get the first piece without an #UNPARSEABLE error. Here's a snip of the smartsheet columns I am comparing and the need is to return what Template to use. There's 10 different "Practice Group or Division" options but the…
-
What is wrong with this formula?
This formula has been working perfectly, but now I am getting an "Invalid Operations" error. What am I missing? =IF(OR(AND(Resolution@row = "BH: On-Hold", [Due Date]@row < TODAY()), AND(Resolution@row = "Correction: Need Follow-Up", [Due Date]@row < TODAY())), "No", IF(OR(AND(Resolution@row = "BH: On-Hold", [Due Date]@row…
-
How to add text from one formula to the result of another formula
Hello, I have two formulas. 1) calculates how many validated units there are. The result is 600. 2) calculates how many units there are in total. The result is 1200 I would like these formulas to combine so the result is 600 / 1200 I am aware I can use +" 1200" but this number will keep changing and the total number to…
-
Pull part of text from a cell
Hello community. I am trying to pull half of this text so that I just get the left hand side of "╏" from the Manufacturer | Model column The Manufacturer column is not working: =LEFT([Manufacturer | Model]@row, LEN([Manufacturer | Model]@row) - FIND("╏", [Manufacturer | Model]@row)) Result = Systimax ╏ 360G2-1U- The Model…
-
How to collect multiple Successor values?
Here's a link to my initial post which helped get me this far. RECAP: I use a combination of a Successor formula & Join/Collect in an attempt to report for my team the next tasks and assignee(s) in our waterfall workflow. I am able to successfully return the next assignee only when there is a single successor. I need to…
-
Stumped on what formula to use
Hello! I struggle with formulas no matter how many times someone tries to show me how easy they can be. I hope someone here can help me figure out this solution, because I'm not sure what I'm doing wrong (or even if what I'm looking to do is possible). I have an intake form I'm using to collect feedback from requesters…
-
Partial Index Match on an identity field
I have set up a dynamic dashboard where users can filter by their name to determine how many documents they are required to complete. On selection of the count a report is opened with the list of documents assigned to them. I am running into an issue on the report when a single document is assigned to multiple people as…
-
Formula Question
I am trying to find metrics on everything that is not multiple things. This is a drop down column that has a list of options and I need to exclude from the count CEG 1, CEG2,...., CEG7 I attempted to use this formula =COUNTIF({ColumnReferencetoSearch}, "<>*CEG*"), but the total it gives me is incorrect (2653). I know this…
-
If Then Formula for 2 Columns
Hello everyone, I'm still a "new" Smartsheet user even though I've been using it for over a year. I want to set up the following formula: if column A equals 1 then column B equals 2. I want to apply the formula to both columns. For more specific details, the terms I'm using are: IF VPM Categorization equals Cost, THEN…
-
Formula to tally revenue from columns in reference
I'm setting up a Metrics Sheet and want to tally up the revenue received for all sessions delivered for each month. For example, I want to know how much in revenue we received for webinars in January, onsites in July, etc. The columns in the sheet are Month, Onsite or Web?, and Revenue for Session. All three columns on are…
