Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.

Discussion List

  • Count If less than 50 rows
    In Formulas and Functions
    Can you do A COUNTIF formula with less than 50 rows or does Smartsheet default to 50?  If I delete the formula in the blank rows I get an "invalid reference" error message. 
    11 3
    11 views 3 comments Most recent by Andrée Starå
  • Formula Help
    In Formulas and Functions
    I am trying to create formula that subtracts to different dates in my data but instead of displaying the date of the result I want it to display "On Time" if less than or equal to zero and "Late" if greater than 0. I g…
    12 7
    12 views 7 comments Most recent by Paul Newcome
  • COUNTIF formula for visual symbol
    In Formulas and Functions
    Hello, I am trying to measure against tasks based on whether they are completed, on hold, not started. I have a status column using visual symbol representation and am trying to determine the countif formula to accomplish this so that I ca…
    153 2
    153 views 2 comments Most recent by Paul Newcome
  • Number of NetDays since last event
    In Formulas and Functions
    Hi, Looking to calculate the number of netdays since an event was recorded. I have a {Date of Incident} column and a {Classification} column Looking for the number of days since a specific classification was reported i.e. {Classificatio…
    31 18
    31 views 18 comments Most recent by Andrée Starå
  • Max value with min collect
    In Formulas and Functions
    I know this is need of a combination of things, but I cant figure it out unless I use a range of cells.  I would prefer to search the collective column to perform the task. I want to return the name of the Visit Provider who has the great…
    51 4
    51 views 4 comments Most recent by ateleoh
  • Compiling Survey Results
    In Formulas and Functions
    Hello All, There's a survey we ask people to fill out so we can better provide services. There are 32 specific locations and a long list of questions. I'd like to compile all of this information into a metrics sheet, and in the end create…
    143 2
    143 views 2 comments Most recent by Kidco Head Start
  • Formula percentage with additional formula for roll up percentages
    In Formulas and Functions
    I am trying to calculate a rolled up percentage of how many students have taken a test, scoring above 80% to those who have not taken the test at all. I have tried an AVG formula as a test for 5 takers, but the % is incorrect. Here is the …
    144 3
    144 views 3 comments Most recent by Mike Wilday
  • How to add a Red Flag when there is an entry more than once in last 12 months
    In Formulas and Functions
    Hi, I have a table which records driving infringements. What I want to be able to do is have a function determine if a driver has had more than one infringement in the last 12 months.   Then use the Actions and Alerts to notify their m…
    21 5
    21 views 5 comments Most recent by Paul Newcome
  • Raise flag if due date is within 30 days
    In Formulas and Functions
    Hi There  I'm very new to smartsheet so for you this might be a very simple thing. I'll appreciate if someone let me know what'd be the formula if I want to raise a flag whenever the due date is 30 days from the current date. We'll apprec…
    219 2
    219 views 2 comments Most recent by Royce
  • vlookup help
    In Formulas and Functions
    OK....so I am struggling with this vlookup.  Perhaps I can not do what I want to do.  Any comments would be helpful. I have a sheet that has customer number and customer name.  Customer number is auto generated and is sequential.  CU10000…
    1 4
    1 view 4 comments Most recent by Sterling