Formulas and Functions
Archives for December 2019
Discussion List
-
SUMIF Halp!In Formulas and FunctionsSo I have this issue I would love to solve. I have a Contract Database (Sheet #1) that holds a current contract value for that contract number (216116). My issue is pulling the child row value (Total Contract Value) to another sheet (Sheet…
-
Reference a cell on another sheet based of a value in the current sheetIn Formulas and FunctionsHi Smartsheet hive mind. Hopefully someone may be able to answer this question. I have a sheet (Sheet A) that will be tracking tickets and will have the dates the ticket was created on it. I have another sheet (Sheet B) that has every date…Answered - Pending Review 31 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Help with formula for multiple criteriaIn Formulas and Functions=COUNTIF([Academic Yr]:[Academic Yr], OR(@cell = "Fall 2019", @cell = "Prior to Fall 2019"), Status:Status, "Active")
-
delay in each TaskIn Formulas and FunctionsIn the created project management fields, there is a start and end dates for the task assigned to the person I would like to inquire about the following cases: When I delay the task completion date, for example 3 days, how can I later revi…
-
Report Based on Multi Select Dropdown ColumnIn Formulas and FunctionsI have a master schedule that includes a multi select dropdown column for disciplines associated with each individual project. I need to create a report that shows all projects with multiple disciples selected. It needs to allow any combin…
-
How do I sum up the last two characters of a cell?In Formulas and FunctionsI have a column where the last two characters are a number. If I do Value(right(cell,2) I get the correct number. I can also add Value(right(cell1,2) +Value(right(cell2,2) But I would like to calculate a cell to be the sum of the right…
-
Summing a columnIn Formulas and FunctionsHi, I would like to count all the rows in a column where the value matches a specific cell. I can get this to work using countif however I can't get it to work when the column is variable. For example Cell A1 = "Yellow", Cell D…Answered - Pending Review 41 views 3 comments 0 points Most recent by SuzanneH Formulas and Functions
-
IF Statement-If text is updated in my "Comments" within the last 5 days I want to return Yellow StaIn Formulas and FunctionsLooking for formula help. I have a comments column that I want to make sure is never more than 5 days old. If the comments field is updated with new or different information - I want to return a Yellow star to the Updated field or a date…Answered - Pending Review 21 views 2 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Can I default cell values to a formula in the form without getting a ' in front?In Formulas and FunctionsI have a form entry sheet where I have some columns hidden but defaulting to a formula. The goal is to have the columns populate with the results of the formulas without any updates required (like cutting and pasting the formula in the gr…
-
General questions about setting up company projectsIn Formulas and FunctionsI literally just started on this yesterday. we have 7 or so departments and projects within each. Our business is a winery--so departments are Production, Hospitality, Wine Club, PR, Marketing etc. Some assignees cross over to projects i…Answered - Pending Review 21 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions