-
How can I send automated updates to submitters?
I am setting up an automation for my client and am having trouble sending out automated messages and wondered if someone could help me with a solution. Here's the structure: Sheet 1: Reports are submitted monthly to sheet 1. (The submitters are not allowed to see the data in the workspace.) Approvers review the information…
-
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…
