Formulas and Functions

Archives for September 2018

Discussion List

  • Countif formula... using crosssheet formula
    In Formulas and Functions
    I've tried both... they don't work they say unparseable... what am i missing I want to I am looking to add up all P1's that have a region of America Break Fix and a status that is not finished or cancelled, then count all the P1's in the…
    32 1
    32 views 1 comment Most recent by J. Craig Williams Formulas and Functions
  • Auto changing status based on due date
    In Formulas and Functions
    Hi, i am hoping this is possible and someone can help? We have created a sheet which is populated from a form and is working really well. We populate the "Required completion date" base on the type of issue and this is automated…
    786 8
    786 views 8 comments Most recent by Paul Newcome Formulas and Functions
  • Using decision symbols to change text
    In Formulas and Functions
    Please can somebody help me, I'm new to formulas! I'm trying to get text in a cell to change depending on what decision symbol has bee selected (YES, NO, HOLD) I managed to get it working with just 'YES' as follows: =IF(Graphic6 = "…
    73 4
    73 views 4 comments Most recent by Marcin P Formulas and Functions
  • Hybrid Report/Sheet
    In Formulas and Functions
    I'd like to use Smartsheet to track performance on a multitude of projects. I can use a Report to quickly gather a list of assignments and compare Need Date to Date Completed.  But I can't add any additional columns (i.e. with formulas t…
    11 1
    11 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Join and Collect Function with Hyperlinks
    In Formulas and Functions
    Hello All, I got my function to work the way I wanted it to, but it did not keep the hyperlinks when it gave me the values. Is there a way to keep the hyperlinks or add them back when using Join(Collect())? =JOIN(COLLECT({Sandbox - DR - …
    22 5
    22 views 5 comments Most recent by J. Craig Williams Formulas and Functions
  • Auto filling a cell based on the entry in another cell
    In Formulas and Functions
    Hi, We have created a form to capture feedback from several stores we manage. How can i get the Store managers name to auto populate on my sheet based on the store name? I dont want this on the form just on my sheet when the entry has be…
    11867 15
    11.9K views 15 comments Most recent by Genevieve P. Formulas and Functions
  • Listing Options in IF formula
    In Formulas and Functions
    I've looked at the forums and tried as many variations in the formula as I can think of, so I need some help.  My two columns (both drop downs): Payee Name Payee Position *(location of formula) I'm trying to get Payee Position to autom…
    11 3
    11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Automated Checkbox column
    In Formulas and Functions
    Hello - I am trying to make my checkbox column automated so that when the PARENT rows is checked all the CHILD rows get checked. I can only find help on the reverse. Can someone help me write that formula?   Thank you Erin
    1 3
    1 view 3 comments Most recent by Paul Newcome Formulas and Functions
  • SUMIF statement based on dates
    In Formulas and Functions
    I would like to create a SUMIF equation to only sum data (column F) based on a date range (column B).  It works in excel with the following equation for reference. =SUMIF($B$9:$B$2000, ">=9/1/2018", $F$9:$F$2000)-SUMIF($B$9:$…
    1434 11
    1.4K views 11 comments Most recent by Paul Newcome Formulas and Functions
  • Trying to calculate dates
    In Formulas and Functions
    I'm trying to have smart sheets calculate a new date. I'm using =[EndDate]5+1 but it's not returning a date. What am I missing?
    21 4
    21 views 4 comments Most recent by Mike Wilday Formulas and Functions