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

  • Calculate RAG Overall Project Status
    In Formulas and Functions
    I have projects that are recording Red, Yellow, Green for multiple categories (Budget, Scope, Schedule, Resources), and I would like to be able to calculate the Overall Health by evaluating each of these individual status' and pulling the …
    1159 6
    1.2K views 6 comments Most recent by Paul Newcome
  • If Current Month
    In Formulas and Functions
    Hi I'm trying to write a formula that will show me a column for the current Month    Currently formula =If(Month(date column)= 9, [Project]1)- This works and displays the correct cell, however I want the column to change with the month …
    232 2
    232 views 2 comments Most recent by Paul Newcome
  • Workload over Calendar Duration
    In Formulas and Functions
    I am very new to Smartsheets and am in process of educating myself on the product to help develop some staffing workload tools on a project basis over time.  The goal is to help us analyze how employees are allocated on a project over a ca…
    40 1
    40 views 1 comment Most recent by Alejandra
  • Formula to see if someone is available
    In Formulas and Functions
    I am trying to build a formula that references another sheet. The goal is to be able to see if someone is working on a project currently. In the reference sheet we have the start date and end date and the Talent's name. So, I am guessing i…
    11 1
    11 views 1 comment Most recent by L_123
  • Index match returns a wrong value
    In Formulas and Functions
    Anyone able to help with an Index/match formula that returns a wrong value?   We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet…
    10403 8
    10.4K views 8 comments Most recent by Paul Newcome
  • COLLECT – IF – DISTINCT Challenge
    In Formulas and Functions
    I want to JOIN(COLLECT) unique, distinct instances of a date given values in other columns. I have a history log of participant registration dates. The participant can register more than one time on a given date. I want to JOIN(COLLECT) al…
    2218 8
    2.2K views 8 comments Most recent by Paul Newcome
  • SUMIF the amount in one column has the correct pipeline status in another column
    In Formulas and Functions
    Can someone please help me with SUMIF, I am losing my mind and keep getting errors.    I have a pipeline document with status' ( approved, declined, awaiting client, in progress,etc) and I need to show in a dashboard the sum associated w…
    23 2
    23 views 2 comments Most recent by L_123
  • IF Statement Check box, not returning check
    In Formulas and Functions
    Hello,  I have a sheet that I am saying if a score is over 80 to check the box. The formula itself seems to be working as it is returning the 1 however I want it to check the box not show me the value.    Any ideas what I'm missing here?
    21 2
    21 views 2 comments Most recent by ShaunaT
  • Formula with multiple IF criteria
    In Formulas and Functions
    Hi all - Trying to create a formula that raises a flag any time a milestone is NOT marked complete AND the due date has past.  Below is what I have tried and I am receiving an "Unparseable" error.   =IF(Stage2<>"Comp…
    22 2
    22 views 2 comments Most recent by Andrea Mayer
  • Automatocally changing due dates and status on recurring tasks (Monthly, weekly, etc)
    In Formulas and Functions
    How do I make a row update the due date for a monthly, weekly, and/or quarterly recurring task? I would like it to automatically change the due date to one month, one week, or three months in the future and change the status back to Not St…
    229 3
    229 views 3 comments Most recent by Andrée Starå