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

  • Countifs
    In Formulas and Functions
    Hi, I am hoping someone can help me. I am trying to count the number of "dates" in one column, compared to how many "dates" are not entered in another column. So for example, Column A has 15 dates in it and Column B h…
    Accepted
    14 2
    Accepted Answer 14 views 2 comments Most recent by Tony DeSantis
  • Merge multiple columns into one?
    In Formulas and Functions
    Hello! I am trying to put together a form through which my staff can request the use of volunteers. To make this form as easy as possible, I've included a question about which department is requesting. Based on logic, that will take the re…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by MCorbin
  • Check a box based on another cell not being blank
    In Formulas and Functions
    Hello! Looking for a way to check a box in column 2 based on column 1 not being blank. I've found variations on this theme, but nothing that quite gets me what I am looking for. Column 1 = Delivery Date Column 2 = check box I want column 2…
    Accepted
    33 4
    Accepted Answer 33 views 4 comments Most recent by Nancy Heater
  • Adding months to a date from separate cell.
    In Formulas and Functions
    Current been working on a few formulas posted previously to add anywhere from 4-18 month to a date. But can not get anything to work. So Start Date 10/01/20 + 18 months. Is there a simple formula that can undertake this? Look forward to yo…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Mike DeLuca
  • Identify Duplicate Values, only within the last 7 days, based on unique identifier (code)
    In Formulas and Functions
    I want to identify when a code is a duplicate in the last 7 days but I'm struggling with the logic/syntax. Essentially people call in for assistance and we track that. When we put a closed date in, automation automatically sends a survey.…
    Accepted
    10 2
    Accepted Answer 10 views 2 comments Most recent by Jennifer Lenander
  • Formula help
    In Formulas and Functions
    Quarter 2 (April- June) I need the formula that does the following: Take the week of 5-Apr + 12-Apr +Apr-19 and that would populate for the [actual number], the remaining weeks would be [planned]. Than dynamically the formula would auto po…
    Accepted
    16 2
    Accepted Answer 16 views 2 comments Most recent by Kelly Miller
  • Matching data across multiple cells
    In Formulas and Functions
    Hi all, I feel like this should be pretty easy but I can't seem to work out how to get this done... I have a sheet with 3 columns that capture different locations - what I am trying to do is return a status/value if all 3 of those location…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Paul Newcome
  • Is there any option for short date that is MMM/YY e.g Sep-21
    In Formulas and Functions
    Currently have sheet that is in short date MMM/YY. We are trying to move this sheet across to smart sheet but an interim period we will still run Excel and copy back over that sheet so consistent format would make thing easy
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Paul Newcome
  • Circular Reference Error Not Appearing Initially, then appears later
    In Formulas and Functions
    I've created a few summary sheets which use VLOOKUPs from my master data sheet, as well as other sheets. I've noticed that when I try to do a VLOOKUP, the formula will initially work, and pull the data as expected. However after some time…
    Answered - Pending Review
    31 3
    Answered - Pending Review 31 views 3 comments Most recent by Filipe Soares
  • Cell-link formula
    In Formulas and Functions
    @Paul Newcome Hey there! Hope you are doing well! Are you aware of any formula that mimics the cell link feature? I've already confirmed that I won't be able to use cell link and I'm hoping there might be another way. Thanks!
    Answered - Pending Review
    32 25
    Answered - Pending Review 32 views 25 comments Most recent by Paul Newcome