Formulas and Functions

Archives for March 2018

Discussion List

  • If then statement for a list of individuals
    In Formulas and Functions
    Good day! I am trying to reference one cell in my spreadsheet that has a drop down list of 30+ people in the list.  I want to create another cell using the if then formula to say if person a, person, c, and person h are in the first cell,…
    91 views 1 comment Most recent by Mike Wilday Formulas and Functions
  • Day of Week instead of short date
    In Formulas and Functions
    Hello,   I would like to have a formula in place that automatically selects a day of week based on the date we paste in the "Bid Date" Column. When 3/26/18 is loaded into [Bid Date] Column it produces "Monday" in the …
    490 3
    490 views 3 comments Most recent by Anthony Lunn Formulas and Functions
  • Dynamically update form data
    In Formulas and Functions
    Looking for help... I'd like to update the fields on a form dynamically. Example:  Use the system-generated Creation Date to calculate a "Delivery Date" 2 weeks in the future and display it on the form.  I know I can do this on…
    51 views 3 comments Most recent by Mike Wilday Formulas and Functions
  • COUNTIFS Statement Help
    In Formulas and Functions
    I am trying to COUNTIFS but have been unsuccessful so far. I need to count the status of a project if it is a certain product. I keep getting #INCORRECT =COUNTIFS(Status3:Status51, "Green", Product:Product, "Rapid Test"…
    1 2
    1 view 2 comments Most recent by Glen Walter Teles Formulas and Functions
  • Newbie Question - Reports Lookup into Sheet (relational database like)
    In Formulas and Functions
    First, I am sure this has been answered, but I could not find it.  I have two smartsheets: Projects and PMs.  The PMs sheet has basic info about the PM (Emp ID, Name, Email).  The project sheet has all the projects we are working in the co…
    32 views 2 comments Most recent by kagrawa Formulas and Functions
  • Vlookup
    In Formulas and Functions
    I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response. I want to use this data to link to another sheet that I am using to track open i…
    11 2
    11 views 2 comments Most recent by Debbie J Formulas and Functions
  • How to add few texts/words on countif(s) formula
    In Formulas and Functions
    Hi, can someone help me on the correct formula that I should use? I wanted to get the number of projects based on their status however the countif formula that I am trying to use doesn't work in Smarsheet but works in Excel. Below is the …
    71 3
    71 views 3 comments Most recent by Chris McKay Formulas and Functions
  • Moving Rows with a Formula
    In Formulas and Functions
    Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list.    Thank you for your help, Sohlbe
    22 1
    22 views 1 comment Most recent by Chris McKay Formulas and Functions
  • Formulas to durations or equivalent
    In Formulas and Functions
    I am building a production scheduler with a built in calculator where by the operator can adjust the labour allocation to test the duration output.  My problem is Smartsheet won't allow durations to be edited by way of a formula. Also I …
    12 views 1 comment Most recent by Taylor F Formulas and Functions
  • Round Whole Dollars Up to Five Dollars
    In Formulas and Functions
    I have a column that takes a rate and decreases it by a discount percent: =[List Rate]@row * (1 - ([Client Discount]@row + [Selected Discount]@row)) For Example $ 300 less 15% discount = $ 255 $ 250 less 15% discount = $ 212.50 $ 90 l…
    121 6
    121 views 6 comments Most recent by Genevieve P Formulas and Functions