Formulas and Functions

Archives for May 2018

Discussion List

  • Stop Counting NETWORKDAY after Done Box is checked
    In Formulas and Functions
    Hi everyone, I'm hoping this is easy to read, it is hard to explain. I am trying to STOP counting days from commencement date of a project once the DONE box is checked. I have managed to make it work without using NETWORKDAY, using this…
    31 2
    31 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • How to total quantity based on similar name in column
    In Formulas and Functions
    I am trying to total points based on the persons name.  Basically one column has the names, some of them duplicates.  Another Column has points.  I need a third column for total points at the end that looks at the names, finds those that a…
    468 2
    468 views 2 comments Most recent by emilyr Formulas and Functions
  • Help with a formula: Do not run formula if cell is blank
    In Formulas and Functions
    Rookie here -- I'm hoping to get some help with a formula issue. I am trying to flag the "Attn" column if "Days Until Due" is less than 120. However,  I don't want the "Attn" column to flag if the cell is blan…
    362 3
    362 views 3 comments Most recent by L_123 Formulas and Functions
  • Mark child if Parent meets criteria
    In Formulas and Functions
    Hi- I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter in…
    32 6
    32 views 6 comments Most recent by Mike Liggett Formulas and Functions
  • Formula for last 24 hours
    In Formulas and Functions
    Hello my friends - I need to create a formula to find any new rows added to a sheet in the last 24 hours.  My created on system column is added.  We currently are using the TODAY function, however, that only captures those added today, whi…
    122 2
    122 views 2 comments Most recent by L_123 Formulas and Functions
  • Date validation on Web Form
    In Formulas and Functions
    Is there a way to validate a date before submitting a form.  The Use-case is:  We have an Event Request Date (Date field) on the form and we don't want the end client to select the close-by dates. We want to add a condition on the form; …
    63 2
    63 views 2 comments Most recent by jaya.c.bandaru Formulas and Functions
  • using Harvey ball status to drive a formula
    In Formulas and Functions
    Hi, Is there a way to use the harvey ball status to drive a formula? Here's an example of what I was able to achieve in excel but cannot replicate in Smart Sheet.  =If(HarveyBall = "Full",date-today(),"") Result in e…
    82 3
    82 views 3 comments Most recent by Chris McKay Formulas and Functions
  • SUMIF Formula - "Dragging" to Copy
    In Formulas and Functions
    For the formula below, when I drag this formula, which references another sheet, across columns in the sheet that I'm writing it, the column referenced in the formula doesn't change. Even though I've done nothing to anchor it, it just rema…
    453 3
    453 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Baffled......Circular / Blocked Reference (Vlookup)
    In Formulas and Functions
    This one is baffling.  I have a problem with 2 sheets reading each others data through a Vlookup.  Each sheet has Vlookup ranges from the other sheet.  I understand why formula and Vlookup may return a #circular or #blocked reference, but …
    187 5
    187 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Check Flag with formula
    In Formulas and Functions
    I am trying to turn on a flag with a formula. I am using the below, my problem is that the flag does not turn red, when I enter the formula the flag disappears and I get a 1. When I take the flag formatting off and change it to text I get …
    395 3
    395 views 3 comments Most recent by Chris McKay Formulas and Functions