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

  • Formula returning #nomatch when flash filled (original formula does not have error)
    In Formulas and Functions
    Hello - I wrote an IF(Index(Match formula to reference a checkbox between 2 sheets (if checked in reference sheet, check in target sheet). The original formula works, but when I attempt to fill the formula down my column, it starts throwin…
    Accepted
    10 2
    Accepted Answer 10 views 2 comments Most recent by Genevieve P
  • Referencing a column from the top down to the current row - WITHOUT ABSOLUTE REFRENCE
    In Formulas and Functions
    I am trying to refer to a column from the #1 row down to the current row in a formula For example say I have a column called Monthly Cost, I could have a formula =SUM( [Monthly Cost]$1:[Monthly Cost]@row) And that formula will very nicely…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Paul Newcome
  • Assigning People using IF Formula or the new Assign People Workflow?
    In Formulas and Functions
    I am setting up a request register where the client logs a request via a form. I want to then notify specific key people depending on what account the request is for to review the request and work on next steps. The people sit in 3 key gro…
    Answered - Pending Review
    15 2
    Answered - Pending Review 15 views 2 comments Most recent by Greg Peddell-Grant
  • Limited characters for a condition within a workflow?
    In Formulas and Functions
    Hi, I am working on setting up a workflow in my Smartsheet. One of the conditions I want to setup is from an existing drop down menu I created in the Smartsheet. Within this drop down, there is an item with a longer title that does not sh…
    Accepted
    20 2
    Accepted Answer 20 views 2 comments Most recent by Paul Newcome
  • URL Query Strings & Contacts
    In Formulas and Functions
    Hi I am using a query string with a form URL to prepopulate a form with row information, which is passed to another sheet. All works but I am have challenges with passing contact info. The source form has a column property of "Contact…
    Answered - Pending Review
    15 6
    Answered - Pending Review 15 views 6 comments Most recent by Paul Newcome
  • Smartsheet marking items late -
    In Formulas and Functions
    Hi (Paul, if you are listening!) I have a formula that determines if an application is on time or late - It is marking applications that come in on the same day as the Final Filing Date as LATE (i.e., received date = 4/20/21 10 am, FFD 4…
    Answered - Pending Review
    10 2
    Answered - Pending Review 10 views 2 comments Most recent by Paul Newcome
  • Cannot calculate future date based on two source fields.
    In Formulas and Functions
    When adding a set of days to a historical date usually that will give you a future date example: =[Sale date]@row + [Delivery days]@row will give me a future date When using Data mesh or Vlookup to bring the two source fields to another r…
    Accepted
    18 5
    Accepted Answer 18 views 5 comments Most recent by Paul Newcome
  • How to add WORKDAY function into a date cell using an IF statement
    In Formulas and Functions
    I'm trying to fill in a date column that if another column is "Y-TK SEND", then the date cell should add 5 business days from another date column. I am able to get it to work if I don't use the WORKDAY function but I need this to…
    Answered - Pending Review
    10 3
    Answered - Pending Review 10 views 3 comments Most recent by Andrée Starå
  • Linked Cells not updating in report
    In Formulas and Functions
    I have created a dashboard to see the daily job status. One of the functions is to see how many jobs are open on Today's task list. This is based on countifs on the date of the task list. The formula's are sometimes working, sometimes not…
    Accepted
    18 3
    Accepted Answer 18 views 3 comments Most recent by Andrée Starå
  • Document generations
    In Formulas and Functions
    We are using Smartsheet forms as most people are to systematically gather data from multiple team members. I have automations notifying team members of updates and new records coming in. I recently set up some mappings from a Smartsheet t…
    9 1
    9 views 1 comment Most recent by Andrée Starå