-
Help with Sumif not recognizing criteria as a percentage
Hi all, Trying to create a field that will tell me what percent of a list of values have exceeded 80%. =SUMIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]7, ">80%", [80% Value Forumula Use]3:[80% Value Forumula Use]7) Goal progress is a percent value i.e. 100% or 45% 80% Value is the number 1 Smartsheet is not…
-
countIf for several values in same column
Hi - Newbie here, but how do you count several text values in the same column? =COUNTIF(Status:Status, "Closed" OR "Deployed") doesn't work
-
Formula & Conditional Formatting Update in Reports
I have several smartsheets that have formulas and conditional formatting. These smartsheets are pulled into a summary report. The formula's and conditonal formatting do not update when opening the report. Each sheet must be opened individually in order for the formula's and conditional formatting to update.
-
IF Function
I am trying to create an IF Function for Various Statuses (Not Started, Hold, Complete) - When selected, Drop Down changes to Gray ball for Not Started, Yellow ball for Hold, Red ball for complete
-
Number Range Logic
I am trying to craft a formula that sources a numerical value in a different column and, based on that value, prints a skill level. Here's the formula: =IF([Points]1 <99, IF([Points]1 <199, “Apprentice”, IF([Points]1 <499, “Amateur”, IF([Points]1 <999, “Pro”, IF([Points]1 <1999, “Veteran”, IF([Points]1 <= 3999, “Expert”,…
-
Number Range for Logic Function
Hello! I have a range of numbers I need to include in a logic function, specifically: < 3 = XS 4-8 = S 9-16= M 17-39= L >40= XL This is my logic string, and I've used a similar one in a previous sheet, but I know my number range isn't correct, but cannot figure out how it should be. Thanks for any help! =IF([Effort…
-
Sum of each Dropdown Option Selected Formula Help
Any Suggestions on the simplest way to formulate this? * Dropdown Column - "Part Status" * Dropdown Options - "Delayed" "Not Started" "In Progress" "Warehouse" "Shipped" I want to show a total sheet sum for EACH Dropdown Option shown. Part Status is only selected on the Parent Rows. Rows 4-287 with 30 Parent Rows. Thanks…
-
Notification when new State is added to list - unique list
Hi, I need to create a notification when we have an order shipped to a State we have not shipped that product to in the past. The client's State is automatically added to the sheet from a workflow, and I need to get notified when ever we have a new State added to the list. I think one way to do is this is to create a new…