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

  • Formula -- If next 4 Columns say Yes/No say something
    In Formulas and Functions
    Hello,    I have a sheet with six columns. They are: Name | Current Step | Step 1 | Step 2 | Step 3 | Step 4   Step 1 - 4 have Yes/No written in them for completion status.    Can I have a formula in Current Step to count how many &…
    101 3
    101 views 3 comments Most recent by Andrée Starå
  • Countif using Dates and another Range
    In Formulas and Functions
    I'm trying to use CountIf using the my auto filled date column and another column. The 2 parts of the formula I have come up with work independent of each other, but when I try to put them together I recieve the #INCORRECT ARGUMENT   reply…
    34 3
    34 views 3 comments Most recent by Paul Newcome
  • Cross sheet sum if
    In Formulas and Functions
    I'm creating a sheet to record the use of agency/contracting staff across a site (once the proof of concept is done it'll be expanded to cover multiple sites), where entries will be added to the sheet below via form. The "within budge…
    11 1
    11 views 1 comment Most recent by Paul Newcome
  • Dashboard icons appear oversized
    In Formulas and Functions
    Just logged into smartsheet and all dashboard icons appear oversized completely disrupting the functionality of shortcut widgets.  This is the first time I've see this.  Same issue on two computer and three different web browsers (IE, fire…
    2 4
    2 views 4 comments Most recent by Andrée Starå
  • Monthly, 6 Monthly, 12 Monthly reporting
    In Formulas and Functions
    I'm currently working on a KPI structure for my organisation. An entry will be made each month via a Smartsheet form, and they'd like to know the latest entry, as well as the last 6 month and last 12 month totals. I'm struggling with how t…
    227 2
    227 views 2 comments Most recent by Garmon D
  • Cell contents into Text String
    In Formulas and Functions
    Hi, I'm trying to create a column that essentially mail merges within the cell by pulling from previous columns. For example: "[Name] is [Age] and attends [School Name] school." where the bracketed terms are columns in the sheet…
    3 1
    3 views 1 comment Most recent by Andrée Starå
  • Populating Sheet Column Content from Report
    In Formulas and Functions
    We are using a unified Asset Tracking sheet in smartsheets for multiple types of Equipment (i.e. Phone, Computer, Printer, etc...). This sheet has basic Asset Tracking information in it but we need to gather additional equipment specific t…
    55 2
    55 views 2 comments Most recent by Paul Newcome
  • Task Status Formula help
    In Formulas and Functions
    I am trying to update the below status formula to update the "yellow" status to be determined by a % complete less than 25% and the Due Date (week of) is between 7 and 14 days in the future.   Here is the current formula: =IF([…
    42 3
    42 views 3 comments Most recent by Andrée Starå
  • hh:mm:ss Time Tracking in Smartsheets? (Probably not possible)
    In Formulas and Functions
    Howdy everyone!  I've got a pernicious little problem that I'm wondering if anyone has any ideas about.   My team and I currently track all of our break/fix help tickets in one dedicated "backlog" sheet. Each task that we need…
    316 8
    316 views 8 comments Most recent by Paul Newcome
  • How to use All 4 Formulas together "IF AND NOT OR "
    In Formulas and Functions
    I have to create a formula that returns a value "1 or 0", so I use the IF statement. Now to satisfy multiple conditions, I am using the AND statement.  Also, to I want to check if the statement is not true, Hence I use the NOT f…
    13 5
    13 views 5 comments Most recent by Mike Wilday