-
Multiple IF statements
Hello, I'm trying to make an IF( formula for the following criteria. If Tech is YES and Curved is YES, 650 If Tech is YES and Curved is NO, 500 If Tech is NO, 0 Thank you!
-
If Contains Contact Cell
I am trying to write what seems like a basic formula, but I'm not getting the expected result. I would like to reference a Contact Cell column with an If(Contains) formula. The basic formula I have written looks like this: If(Contains("John Smith", [Received By]@row), 1, 2). The result is always returning false ("2") even…
-
If Formula Help: =IF X symbol and X symbol are X, display X in this column
I'd like to select text in a column based on symbol indicators in a column. For example if they are highly impacted, with a "!" symbol and they are not influential with a (down arrow) symbol, i want to indicate that i should reach out to them weekly. See pic. Please help with how I can set up the formula to do this…
-
If / Contains combination
Just recently, we have been experiencing automated workflow messages triggered based on formulas that are years old 😯 It appears that these messages are triggering each time a user sorts the originating sheet a different way. In an attempt to debug the issue, I found the below. Any thoughts as to why the destination…
-
Need Help with IF Statement with Countif
Hi Smartsheet community. I have been working on a formula and it has not been working. Wondering if I am going about it the wrong way? I am working on a lessons learned project sheet where i am confirming if a root cause issue is being repeated or if it is new. This information is in the same sheet. My formula is below.…
-
Assigning Score to Multi-Select Dropdown Menu Options
Hi, I need assistance with assigning a score for outputs using a multi-select dropdown menu. Essentially, I want to be able to assign a numerical value when someone selects a choice from a multi-select dropdown, however, I am only able to assign a score for one answer. When multiple options are selected, the IF formula I'm…
-
Cross Sheet Index, Match, and IF
Hi, Thank you for coming to my help, I really hop this question makes sense. Basically, what I want to do is take the closest date of incomplete tasks and put it into another sheet where I can run automation asking someone to update a report. The reason I want to do it this way is because on the report you could be…
-
Task Health Indicator Formula (IF/AND/OR)
Got burnt out looking for my exact scenario in the forums, so looking for direct help. Trying to create a formula to automate my Health column KPIs based on task status and assigned dates. Status options: Not started, In Progress, Blocked, Complete Desired Status Colors Blue: Status = Complete Red: Status <> Complete AND…
-
Check Box Across Sheets
Hi, I have two sheets, one is an intake sheet and the other is a metrics sheet. Metrics Sheet Plan has an OR(ISDATE( Formula to raise flag is a date is entered Agents has an IFERROR(INDEX(DISTINCT formula to capture the agents from the Intake Sheet Intake Sheet I want to add a Formula that can Raise a Flag under the PLAN…
-
IF/COUNT and IF/SUM/CHILDREN Formula Help
I have a sheet (See below). In the 'Sheet Needed' column I have a formula: =IF(P@row = 1, COUNT([Sheet Created?]@row, IF(P@row = 0, SUM(CHILDREN())))) This is working in the Child Rows, however I am not getting a total in the Parent Rows. What am I doing wrong? I know it is late at night and I am sure I am doing something…
