Formulas

Discussion List

  • Formula Question - Pulling in Multiple Criteria
    In Formulas and Functions
    I currently have a couple COUNTIFS formulas where I'm capturing the type by person by month as my criteria. I need to keep this criteria but add the condition that if multiple workers is selected in the source sheet (in a drop down with 3 …
    Accepted
    24 4
    Answered ✓ 24 views 4 comments Most recent by rmc0030 Formulas and Functions
  • Formula in metrics sheet to average numbers in column in source sheet
    In Formulas and Functions
    I have a source sheet containing two date columns and a helper column containing a formula to calculate the network days between the date columns. (Example of several rows of my 600+ row source sheet.) In my metrics sheet, I want to calcu…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by Jeff Reisman Formulas and Functions
  • Formula for difference in time
    In Formulas and Functions
    We run events and are putting together the tech runsheet which has a column for: Time Start Time Finish Timer The timer column is what a speaker sees on their foldback monitor for how long they have left to present. I need this column to s…
    Answered - Pending Review
    23 2
    Answered - Pending Review 23 views 2 comments Most recent by Jimrny Formulas and Functions
  • Numerical "Priority" Method
    In Formulas and Functions
    Hello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column …
    Accepted
    11 3
    Answered ✓ 11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Multiple IF and IF (AND) arguments in one formula
    In Formulas and Functions
    Does anyone see any obvious issues with this string? I'm trying to pull from two columns [VA Feed status], [QA Feed status] and output one status based on the column statuses. This is a combination of IF(AND) and also just IF statements. …
    Accepted
    24 2
    Answered ✓ 24 views 2 comments Most recent by Savannah O Formulas and Functions
  • Indicating a row is past due
    In Formulas and Functions
    Hello everyone, I was wondering about a capability in Smartsheet. I was hoping to indicate a row was not completed on time. I am not talking about conditional formatting per say. I do not have a preference how this is shown but I was think…
    Accepted
    14 3
    Answered ✓ 14 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • How to Alter the "Sheet - IT Ticket Metrics"
    In Formulas and Functions
    I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt…
    Accepted
    14 5
    Answered ✓ 14 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Formula or conditional formatting for highlighting unique task names
    In Formulas and Functions
    Hello Smartsheet Community, I wanted to "copy" condition made in excel into my Smartsheet, and can't get it done right. I would need to highlight unique title for the task, which doesn't exist in a different raw. I tried some dif…
    Answered - Pending Review
    24 2
    Answered - Pending Review 24 views 2 comments Most recent by Kamila Sroka Formulas and Functions
  • Collect record for previous day to Calculate variance
    In Formulas and Functions
    Main problem: I am attempting to collect the record of Daily absent for the previous day, I get incorrect argument error. I could use any help. My end goal is to use the previous day record against the daily absent record to get the varia…
    Accepted
    72 3
    Answered ✓ 72 views 3 comments Most recent by Kelly Moore Formulas and Functions
  • Mid Date between 2 dates
    In Formulas and Functions
    Hello, Can anyone help me with a formula to find the mid date between 2 dates. Like what will be the mid date between 1st Jan 2021 and 31st March 2021.
    Accepted
    119 6
    Answered ✓ 119 views 6 comments Most recent by EJ Formulas and Functions