Formulas

Discussion List

  • Nested CountIFS
    In Formulas and Functions
    Hello, I am stumped! I am trying to raise a flag when one cell is blank and 2 other cells match another row. In the example below, the first 2 rows should not be flagged because on is G8 and one is G9 in the Core Program column. The yell…
    Accepted
    16 3
    Accepted Answer 16 views 3 comments Most recent by Heather Duff Formulas and Functions
  • If/Then type formula
    In Formulas and Functions
    I have three percentages that are fed in a sheet summary. I can write this formula in the same sheet summary so there is no reason for cross sheet references. I need to write a formula that calculates the median of the three percentages. …
    Answered - Pending Review
    18 7
    Answered - Pending Review 18 views 7 comments Most recent by Genevieve P. Formulas and Functions
  • Employee Pulse Survey Template Set Formula Question
    In Formulas and Functions
    Hello I downloaded the template set for the employee pulse survey when I customized it, the formula to score the questions got erased. Does anyone have the the formula for the helper columns to assign a number next to the survey result? Fo…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by HFletcher Formulas and Functions
  • Formula to Capture Previous, Current, & Next Quarter
    In Formulas and Functions
    Hello, I have a spreadsheet with information populated from Jira. Unfortunately it does not contain information like start and finish date, but uses quarters instead. I am creating a dashboard with pulling reports for Previous, Current,…
    Answered - Pending Review
    25 3
    Answered - Pending Review 25 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • How to change first week number from Jan 1 to July 3 ?
    In Formulas and Functions
    How to change first week number from Jan 1 to July 3 ? 
    Answered - Pending Review
    14 5
    Answered - Pending Review 14 views 5 comments Most recent by Genevieve P. Formulas and Functions
  • #Unparseable error, please help
    In Formulas and Functions
    Hi, sorry to bother, because I know this can be a very dumb question but I have tried all the ways with no luck. I keep getting this error and I don't know where is the error. I want to sum a column called "2022OpEx" only if the…
    Answered - Pending Review
    12 8
    Answered - Pending Review 12 views 8 comments Most recent by Xochitl Cerda Formulas and Functions
  • Last update Formula (Sheet Summary)
    In Formulas and Functions
    I need to make a formula that identifies the last modified date on my sheet
    Accepted
    15 2
    Accepted Answer 15 views 2 comments Most recent by Luis Rosario Formulas and Functions
  • Count Ifs with multi-select
    In Formulas and Functions
    Hello I'm trying to do a count if with a multi-select column and am using the find formula. It is referencing another sheet. can you please let me know if I have any errors here? I get #Invalid Data Type.
    Answered - Pending Review
    17 8
    Answered - Pending Review 17 views 8 comments Most recent by Heather Duff Formulas and Functions
  • weighted task %, % complete by time
    In Formulas and Functions
    Hi, I'm having trouble wrapping my head around how to produce a formula for my scenario. We are considering each task (hierarchy 1) a percentage of the overall project. For example, research is 5% of the project, production is 25%, etc. …
    Answered - Pending Review
    41 1
    Answered - Pending Review 41 views 1 comment Most recent by Matthew Flebbe Formulas and Functions
  • Nested Index/Match if Partial Text
    In Formulas and Functions
    I require a cross-sheet formula that will search for a Task (row) in another smartsheet, if the Task ‘Comment’ (column) contains the word “All”, then go to another Task row and index the Date. If the Task ‘Comment’ (column) does not includ…
    Answered - Pending Review
    35 1
    Answered - Pending Review 35 views 1 comment Most recent by ChelseaH Formulas and Functions