-
Trying to create a formula that determines the current season
I've got a formula that generates the current quarter and one that calculates the current year. Now I'm trying to write an IF statement that creates a value that says S23 by reading if its Q1 or Q2 and then adding the 23 from the current year (2023). This is my current formula, can anyone explain why it's not working or…
-
COUNTIF or IF Statement
I am looking to add date columns that are based on a criteria in another cell. I can use the COUNTIF statement to add the dates but when I place an criteria in place I get an error. =COUNTIF([Due Date]:[Due Date], <=TODAY()) This works to count my dates that are less then or equal today but I need it also to filter out if…
-
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…
-
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…