Formulas and Functions
Archives for May 2020
Discussion List
-
Need help with an "IF", "CONTAINS" and "OR" formulaIn Formulas and FunctionsHello everyone First, thanks for your help :) I'm trying to make a formula. I have a cell (cell#1) that has 4 values in it (" one", "two", "three", "four"). I'm looking for a formula that would wor…
-
Display date fields from two different sheetsIn Formulas and FunctionsHi, I'm tracking an estimated Start and End date (in a Project Sheet) and an Actual Start and End date (in a tracking sheet). In both sheets the rows where the dates are entered are CHILDREN and they both have an Asset # that I'm can match…
-
IF(OR Statement giving #unparseable, using ; or , ?In Formulas and FunctionsPlease help. I keep getting #unparseable error for the following formula: =IF(OR([DLExpiration Date]1 > TODAY(); [MECExpiration Date]1 > TODAY()); "NON COMPLIANT"; "COMPLIANT") I want the cell in my Status colu…
-
I get an #INVALID OPERATION using SUMIFS with multiple criteria referencing a separate sheet.In Formulas and FunctionsI am having trouble getting this formula right. I want to pull the qty of flooring scheduled to run in a given week (1-52) provided it requires one of 2 types of veneer. (Acacia 1220x077x1.5 or Acacia 1220x185x1.5) =SUMIFS({Schedule File …
-
How do I show health based on end date & % complete?In Formulas and FunctionsI'm trying to show health of a project based on how far out from End date + how much of the work has been completed. Green: 100% complete before or on End date Yellow 70-99% and today is < 1 range of End Date <69% and date within 2 …
-
Workaround for broken UTC System Created Date ColumnIn Formulas and FunctionsHi, my problem is the same as in https://community.smartsheet.com/discussion/19461/wrong-date-showing-seems-to-be-4-hours-off-the-difference-between-gmt-and-my-time-zone In short, I am on GMT-7 time, while Smartsheet operates under UTC. B…Accepted Answer 77 views 6 comments 0 points Most recent by Werner Gerstacker Formulas and Functions
-
How do you create a Sum if equation when the criteria is based on a value in a Multi-Select ColumnIn Formulas and FunctionsWhen I chose just one of the selections (I have been using "Product" no" = "or other signs) it only sums the values were there is only "Product" . the equation wont sum if there are other selections included.Answered - Pending Review 12 views 2 comments 0 points Most recent by Andrea Hill Formulas and Functions
-
How can I create a stacked bar graph that shows different sets of data?In Formulas and FunctionsHi! So I have two sets of data that I would like to graph using a stacked chart. Data set 1 contains a number of actions that are divided by month, for example, the month of May has 5 actions and the month of June has 3. Data set 2 contain…Answered - Pending Review 18 views 1 comment 0 points Most recent by Genevieve P Formulas and Functions
-
Adding Months and Placing Data in a Month ColumnIn Formulas and FunctionsSheet --> https://app.smartsheet.com/sheets/Rp5CHm6mFGcw2CG7x8rFjmfGwVpG394xffJw2x91 I really need some help placing data throughout this sheet by using formulas. I know what I want but I dont know the formulas. I want the total mont…Answered - Pending Review 34 views 1 comment 0 points Most recent by Sean Morgan Formulas and Functions
-
how do i automatically check a box when 2 other boxes are checked in a row?In Formulas and FunctionsWhen "Connect Done" and "Core/Micro Done" are both checked, I want "Client Done" to automatically be checked. Can someone help me with the formula? I'm guessing its an =IFAnswered - Pending Review 36 views 9 comments 0 points Most recent by Andrée Starå Formulas and Functions