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

  • confused about VLOOKUP across sheets
    In Formulas and Functions
    I can't figure out how to make the function work or I'm trying to do something not supported. Basically, I want to pull the value of a cell from a row on sheet B and put it in a cell on the same row in sheet A. I'm not looking to perform …
    509 4
    509 views 4 comments Most recent by joechap
  • Determining Resource Allocation for Resource View
    In Formulas and Functions
    Hello! I am trying to find a way to determine resource allocation in project plans so that they more accurately reflect the availability of my team in the resource view. We have individual project plans for each project, which all fe…
    74 2
    74 views 2 comments Most recent by ABogle
  • VLOOKUP Confusion
    In Formulas and Functions
    I'm very confused about how VLOOKUP has been implemented. * Can the search value reference a value in another column in the current row, or can it only be a string enclosed in quotes?  If it can only be a string, it makes the function pre…
    221 2
    221 views 2 comments Most recent by jiwhite
  • VLookup Range Changing - UPDATED - RESOLVED
    In Formulas and Functions
    I have a sheet of VLookups which I get to be working perfectly then when I come back later (sometimes as little as 10-15 minutes) most cells have been changed to "No Match". To fix this I simply have to re-input the range to what…
    260 views 2 comments Most recent by Daniel Stein
  • Automating RYG Status Balls Based Off Two Date Columns
    In Formulas and Functions
    I have two columns "Actual Start Date" and "Actual End Date", I want to have a formula for the status column using the RYG Status balls that will: - Red when nothing is in either of the two cells - Yellow when there i…
    51 views 1 comment Most recent by Shaine Greenwood
  • COUNTIF Formula Question
    In Formulas and Functions
    I'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are in the next 7 days and ALSO be able to…
    42 views 1 comment Most recent by Jim Hook
  • Checkbox Formula
    In Formulas and Functions
    Hi there, I have created a document designed to check off whether or not we have received scores back from our partners using a column of check boxes. I need to input a formula that counts the boxes that have been checked off versus the to…
    12 1
    12 views 1 comment Most recent by Andrée Starå
  • Semicolons in German language settings
    In Formulas and Functions
    Hi community, I had a hard time with Smartsheet support (used to be different) regarding my issue. Has anyone else with Smartsheet set to german speaking setup the problem described below? Starting some time last week, Smartsheet starte…
    13 3
    13 views 3 comments Most recent by Stefan 7k
  • Formula to have status "ball" change color for blank cell
    In Formulas and Functions
    I would like to have the status "ball" color change to red if the column cell is blank and green if the column cell has a date entered in it.   PLEASE HELP!!!!!!
    266 views 2 comments Most recent by Mike Wilday
  • Defining a range using a variable as the row #
    In Formulas and Functions
    Hi, Newbie question here. Let's say we have a simple SUM formula: =SUM([Column1]15:[Column4]15) Is there a way to specify the row # using a variable or some kind of reference to a number value in a cell? For example, rather than "…
    148 3
    148 views 3 comments Most recent by J. Craig Williams