Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Discussion List

  • Need help summing data from a specific Month
    In Formulas and Functions
    Hi everyone, I need assistance summing and counting data from a specific month. For the "Actual" column, I need two formula's in which it sums all the values up until the date I have under the "Date column", I also nee…
    Accepted
    21 7
    Answered ✓ 21 views 7 comments Most recent by Rainier Hollands
  • VLOOKUP with Multi-Select Column
    In Formulas and Functions
    This discussion was created from comments split from: Announcing Formula Support for Contact Columns.
    Answered - Pending Review
    130 2
    Answered - Pending Review 130 views 2 comments Most recent by Andrée Starå
  • Generate row IDs with new rows on top
    In Formulas and Functions
    Hey! I have a sheet in which rows are added from a Smartsheet form. In the form, I used the feature that new rows are added on the top of the sheet instead of the bottom. So every time there is a new entry the first row is the last entry. …
    138 1
    138 views 1 comment Most recent by Andrée Starå
  • COUNTIF EXCEPT
    In Formulas and Functions
    Hello, could you help me find a formula that counts all except "x". I have a Column that has data such as: dates, "ok" and "N/A". I try using the Countif formula but cant seem to figure how to have it count a…
    2029 4
    2K views 4 comments Most recent by Andrée Starå
  • Smartsheet formula
    In Formulas and Functions
    Hi Can you please suggest me with a formula that carries out the following function for me: IF %column = 100%, "Complete" IF%column = >25% and <=99%, "In Progress" IF %column = <25% "At Risk" IF %c…
    Accepted
    22 3
    Answered ✓ 22 views 3 comments Most recent by Brett Wyrick
  • Customizable Map Chart
    In Formulas and Functions
    Hello - I am looking to be able to show impact across the US visually on a map. For instance color code tier 1 states red, tier 2 states yellow, tier 3 states green. I have attached a picture of what I am thinking I would like to develop…
    Accepted
    151 3
    Answered ✓ 151 views 3 comments Most recent by Andrée Starå
  • How to return blank rather than 0 with COUNTIF formula
    In Formulas and Functions
    Hi - I have a 'COUNTIF' formula in a Roll-up Summary that is referencing a column with dates in another sheet to provide a count of dates within a specific range. If no dates are found within the date range specified, it is returning a '…
    Answered - Pending Review
    454 1
    Answered - Pending Review 454 views 1 comment Most recent by steven.reed14881
  • OR function Not Working with Multiple Logical Expressions
    In Formulas and Functions
    Hello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. Howe…
    Accepted
    89 9
    Answered ✓ 89 views 9 comments Most recent by Andrée Starå
  • how to realize a projectplan with planned start/end/effort/duration vs. actual start/end/effort/....
    In Formulas and Functions
    Hi all, we are successfull planning projects with smartsheet. Now we would like to compare planned start/end/effort/duration vs. actual start/end/effort/duration. Any idea how to do that? Baseplans? How to visualice two gantt bars planned …
    Answered - Pending Review
    24 2
    Answered - Pending Review 24 views 2 comments Most recent by Joachim Mund
  • Date Formula
    In Formulas and Functions
    I am creating a sheet to be used as a template for tracking tasks per contracts. For invoices, I would like to have a section that will have Invoice 1, 2, -12 but I would like to just be able to input one date and then have the other date…
    Accepted
    84 9
    Answered ✓ 84 views 9 comments Most recent by Pamela Wagner