-
Formula help
I'm looking to write a formula that looks at cell A1 and if it contains "Sent" within the text of the cell, it grabs the number in cell B1 and writes it in C1. Example: Cell A1 = "Sent w Statement" Cell B1 = $100.00 I need C1 to populate $100.00 because A1 has the word Sent within the text Any assistance is greatly…
-
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…