Formulas and Functions

Archives for March 2019

Discussion List

  • Formula with COUNTIF and Checkbox
    In Formulas and Functions
    I have this working formula:  ="Unit 2G  is " + ROUND((COUNTIF([Unit Name]:[Unit Name], "2G") / 14) * 100) + "% Completed" 2G could also be 3G, 4H, and 2H. (Dropdown selection list) I have a checkbox colu…
    11 2
    11 views 2 comments Most recent by ricki Formulas and Functions
  • Weekly Tracking for a Dashboard
    In Formulas and Functions
    I have a grid where I am trying to lookup from a grid that people can log issues on. The first lookup is the date range, we want to count all issues within that date range. Then we only want to count by the "Field". On the log it…
    93 9
    93 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Countif after certain date
    In Formulas and Functions
    Hi! I'm trying to create a formula that will count the number of rows that have a "Delivery Date" after 1/1/2019. Any row with a date prior to that should not be counted. I also do not want blank rows counted. In the screen cap…
    JAA Profile Photo JAA
    543 10
    543 views 10 comments Most recent by JAA Formulas and Functions
  • Symbols Formula. How do I make a symbol depend on two other columns?
    In Formulas and Functions
    Hello! I am trying to make a symbol formula that will become "1" (red flag) IF the Start date is in the past, AND if a dropdown list DONT show "Done".   Anyone that has this formula or knows how to write one?   Kin…
    61 views 9 comments Most recent by Andrée Starå Formulas and Functions
  • Total Sum By Month selected on Dropdown
    In Formulas and Functions
    I need to be able to select to view the total cost of children by a certain month. Currently, I have the dropdown values of all 12 months. I have the formula to the right of the dropdown calculating the total cost recorded for each child.…
    244 15
    244 views 15 comments Most recent by Paul Newcome Formulas and Functions
  • Check if one contacts column matches another
    In Formulas and Functions
    I want to set up a notification for when a row is modified by someone NOT in a contact list column of "assignees". The idea is that if someone not in the assignees cell modifies the column, then I would notify the assignees. I w…
    114 6
    114 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Need report that only shows fields that are NOT blank
    In Formulas and Functions
    Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column wi…
    266 1
    266 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Countif but only if?
    In Formulas and Functions
    So I am trying to count the number of times a person worked on a specific task.  I have various "types", each person might have worked on the task in a different role (Lead SME, SME 2, SME 3), and then I have a check mark whether…
    1 6
    1 view 6 comments Most recent by Shesha_K Formulas and Functions
  • effort and allocation-based timelines?
    In Formulas and Functions
    We have a small team, with each member having very a specific area of expertise. As such, our timelines are defined by prioritization of tasks, dependencies, effort, and resource allocation. I want to enter my tasks, set their dependencie…
    51 1
    51 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Formula Help!
    In Formulas and Functions
    Hi, I'm new to Smartsheet and the community.  I am trying to trigger a flag on my sheet to alert me when: - The status of my project is not complete, 5 days before the end date - The status of my project is in progress, but less tha…
    21 13
    21 views 13 comments Most recent by Paul Newcome Formulas and Functions