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

  • Combining IF Formula - Is This Possible?
    In Formulas and Functions
    Hello, I'm working on a formula that will trigger a status of "complete" based on a Task Reviewed column. =IF([Task Reviewed]5883 = 1, "Complete", PARENT()) I am trying to combine the formula with another one that will …
    Accepted
    19 3
    Accepted Answer 19 views 3 comments Most recent by Kelly Drake
  • Estimating Available Award Dollars when awards have asynchronous start dates.
    In Formulas and Functions
    Background: We're a research organization that receives a variety of federal, state, and private awards to conduct research. Awards are received throughout the year with a variety of project periods ranging from 1-5 years. Objective: Deriv…
    Unanswered
    14 0
    Question 14 views 0 comments Started by Alex T.
  • Counting Hearts
    In Formulas and Functions
    We are using a sheet to rate name suggestions. Each employee has their own column and they rate each name suggestion using the heart scale. Does anyone know how to count/sum the total numbers of hearts in a row? Example: I rate a name …
    KLP Profile Photo KLP
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by John Jonassen
  • Project Dates and Coming in on time
    In Formulas and Functions
    Hi, I'm trying to set up a project template using a Gantt chart so that when the Certificate of Occupancy date is plugged in, it will automatically populate the goal dates for all the tasks prior, based on how long those tasks take, in ord…
    Unanswered
    14 0
    Question 14 views 0 comments Started by Janelle Carrier
  • Find Difference between two Cells that could be Multiselect Dropdowns or Text
    In Formulas and Functions
    I am pretty advanced when it comes to smartsheet and formulas. But this one has me stumped. I am trying to find a way to report on the difference between two text or multiselect cells. Any advice would be much appreciated.
    Answered - Pending Review
    34 10
    Answered - Pending Review 34 views 10 comments Most recent by Thomas Bostwick
  • How to display results from original smartsheet in another smartsheet to create a dashboard
    In Formulas and Functions
    Hello! I am creating an executive summary dashboard for people external to our company. I have a data source smartsheet (primary) that has a lot more detail that I do not want to give them access to. I would like to create a smartsheet …
    Answered - Pending Review
    19 5
    Answered - Pending Review 19 views 5 comments Most recent by Paul Newcome
  • Count number of registrants from each company
    In Formulas and Functions
    I feel like I'm missing an obvious function here. I'm using smartsheet to register attendees for a virtual event. I'd like to add a chart on my dashboard that shows the number of registrants from each company. I know how to do a count if f…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by MCorbin
  • Form - Restrict input of a past date
    In Formulas and Functions
    Hi, I am re-opening this question to know if any updates have been made since? The question is related to the Smartsheet Form, on having an option to restrict a sender from being able to enter a past date in a form. Related discussion o…
    Accepted
    14 5
    Accepted Answer 14 views 5 comments Most recent by Andrée Starå
  • Concatenate Existing Columns
    In Formulas and Functions
    I have an existing sheet with hundreds of lines of data. We recently decided we needed to combine two of the columns, but don't want to have to go through each line and combine them. Is there a formula I can use to copy the information fro…
    Answered - Pending Review
    21 3
    Answered - Pending Review 21 views 3 comments Most recent by Marinda Hanson
  • SUMIF Formula Help!
    In Formulas and Functions
    I am trying to type a sum if formula where it will add up a whole column based off of ONE criteria. The formula is working but it equals to 0 every time when that is not what the actual answer is. Please help! Ex: I want to sum up the numb…
    Accepted
    8 10
    Accepted Answer 8 views 10 comments Most recent by Andrée Starå