Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Discussion List

  • 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…
    92 2
    92 views 2 comments Most recent by ABogle
  • 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…
    383 2
    383 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…
    62 1
    62 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…
    61 1
    61 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…
    42 3
    42 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!!!!!!
    433 2
    433 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 "…
    276 3
    276 views 3 comments Most recent by J. Craig Williams
  • Formulas and Referencing Sheets
    In Formulas and Functions
    So with the new referencing sheets feature (at least I think it's new) is it possible to have one sheet that would be the master for all summaries and metric information rather than roll them up into extra rows at the top of each sheet?  
    22 1
    22 views 1 comment Most recent by J. Craig Williams
  • Daily Notification
    In Formulas and Functions
    Hi All,  Is there a way to send a daily notification when a task is not complete? The way my sheet is set up is the RYG dots are automated depending on the due date, and based on those dots, notifications get sent (Yellow is the due date,…
    72 1
    72 views 1 comment Most recent by J. Craig Williams