-
Issue with CountIFs function
Hi all i'm currently attempting to use a COUNTIF function to count with 3 conditions. However my output comes up with 0 when there are more than 0 items that meet the criteria. Can anyone assist to see if my formula is incorrect? =COUNTIFS({Type}, HAS({Type}, "Storyline"), {Current Maintenance Assignee}, "Earl Prentice",…
-
How do I total the answers from a drop-down cell?
I'm trying to build a dashboard that will show the progress of sites completed for an upcoming upgrade. I have attempted several ways to compile this information automatically and I'm at a loss. I think a simple cell formula might be the easiest way to accomplish what I need then I can link the cell to a report I create.…
-
Formula to check for duplicate values across six columns
I'm trying to create a formula to check for duplicate values across six columns. I have a formula that shows if columns 2-6 contain a duplicate of column 1. However, I need to check if columns 2 & 3 are duplicated, and so on and so forth. How can I modify the formula below to do this? Thanks! =CONTAINS([Field of Study…
-
What formula to use to add $ and comma in the field
I have a "run-rate" field that sums up values from 4 other cells. What formula can I add so the summed value automatically has the $ sign and comma between the numbers? Also, can I use the same formula in the other 4 cells so that people don't have to add $ and comma when inputting data? Thank you
-
Identify Duplicate Values On Select Dropdown Selections
I want to identify any new rows that are trying to use the same filename as an existing row. We do have reuses, so I do not want those flagged. I was able to set up a checkbox helper column for Duplicates that identifies any filename that is repeated in that column. =IF(COUNTIF([Filename]:[Filename], [Filename]21) > 1, 1,…
-
Need some help with a health formula for task risk level analysis
Hello, I am currently working on a formula for the health column in my smartsheet that is based on the the task status and the end date of that particular task. This is what I have so far but what I need is for when the "end date" cell is blank I would like for the health of that task to be blue. The reason is we do not…
-
IF with multiple contingencies
=IF([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row > 5, "yes", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row = 5, "hold", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3…
-
Totals From SUMIFS Displaying Incorrectly Within Sheets and Dashboards
Hi all, Wondering if anyone has any ideas or insight into data not displaying properly within graphs on a dashboard. The issue I experience is that data displays during the wrong 'time' or is assigned to the wrong criterion. Here's the issue: I have a data sheet that gets multiple form submissions per hour - sometimes…
-
IF formula with AND OR nested
Hello, I'm attempting to create a formula that will determine if one or both options have been selected in a dropdown and assign that a numerical value. What I have now is =IF(OR([Communications provider]@row = "Provider A", [Communications provider]@row = "Provider B", AND([Communications provider]@row = "Provider A",…
-
countif with dates
Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2018. Thanks =COUNTIF([Date Completed]1:[Date Completed]14, "=>1/1/18")