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

  • Date Automation is not working
    In Formulas and Functions
    I've got an automation set up in a way that if a row is added, the date gets captured. However, when adding data to a new row, this does not seem to work. I've even waited for 30 + mins since some discussions have mentioned a 'delay' in th…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Paul Newcome
  • Using several conditions
    In Formulas and Functions
    I am trying to build several conditions into my Smartsheet, is there a limit as to how many we can have? This is the conditions I need to have set: GRAY - when renewal status column status are selected: Awaiting Information, Bound (Lead)…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by Genevieve P
  • Formula Dates vs Gantt display
    In Formulas and Functions
    Hi all, I have an issue using function + dates + showing them in a Gantt chart. The scenario is the following: I have three columns set as type Date: Contractual date, Starting date (of execution) and End date (of execution) The Contract…
    Accepted
    22 2
    Accepted Answer 22 views 2 comments Most recent by Mihai Nedelcu
  • 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