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

  • Work days formula
    In Formulas and Functions
    Hi,  Is there any way you can advise of a formula where I can set something up that picks a date in a column and I set a specified number of working days which yields the final date. So if I have a cell with a date of 10/09/19 and the wo…
    65 6
    65 views 6 comments Most recent by Paul Newcome
  • Mandatory text to activate checkbox
    In Formulas and Functions
    I have a "Notes" column that requires text before the checkbox under "Req Attn" will be checked, kicking off conditional formatting in other columns.   I found this thread and tried to implement the suggested solution…
    37 8
    37 views 8 comments Most recent by Andrée Starå
  • COUNTIFS - Overdue tasks
    In Formulas and Functions
    Hi, I am trying to count live tasks that are overdue but I am getting #INVALID DATA TYPE This is the formula I am using =COUNTIFS(Status:Status, <>"Complete", [End to End Due Date]:[End to End Due Date], <=TODAY()) A…
    481 9
    481 views 9 comments Most recent by Paul Newcome
  • Multiple IF Statement based on Multiple Criteria
    In Formulas and Functions
    I am currently working on automating an "Assigned To" column based on postal codes. There are multiple postal codes options per individual with three individuals. Is there a way to create a (albeit very long) formula to populate?…
    Accepted
    209 5
    Answered ✓ 209 views 5 comments Most recent by Paul Newcome
  • IF, AND, OR Formulas
    In Formulas and Functions
    Using my data set, I would like to know by region the number of multi-year reporters and new reporters (2018). I will count either status as an active reporters.  Ex. Africa= total 2 active reporters -Ghana: Multi-Year Reporter -South A…
    2 1
    2 views 1 comment Most recent by Paul Newcome
  • Summary Task status - automatic
    In Formulas and Functions
    Hello, Im very new to smartsheet, so, im sorry if this question is too "basic".   I have a summary task with 3 or 4 children tasks. I would like to know if there is any way to automatically update the status of the summary ta…
    208 3
    208 views 3 comments Most recent by Paul Newcome
  • IF or IF AND Formula conditions DATE
    In Formulas and Functions
    Dear, I appreciate your help. I need to create a formula that changes the status column depending on the following conditions. (The image in the example table has reference TODAY = August 28, 2019) 1) If the Balance column is equal to 0 …
    220 19
    220 views 19 comments Most recent by Gerardo_Clarke
  • Identify duplicate dates and exclude blank cells
    In Formulas and Functions
    I am working with a SmartSheet that is used by multiple people to schedule meetings.  I am trying to check for duplicate meeting dates within two columns "Proposed Date" and "Proposed End (if multiple days are needed)".…
    297 1
    297 views 1 comment Most recent by Sean Morgan
  • How Nested IF can I get?
    In Formulas and Functions
    I have a desire to change a Status column based on whether (or not) certain separate (other) columns are populated with a date.  Is this supposed to work?  All of the Nested IF examples I have seen tend to look at just a single column to e…
    23 9
    23 views 9 comments Most recent by khankoff
  • Index or Vlookup or What?
    In Formulas and Functions
    Hey All! I have a question for the community that i'm having trouble figuring out to return a certain value to another sheet based on criteria. The pic I attached shows a project budget setup and I am wanting to pull data from the Budget …
    163 3
    163 views 3 comments Most recent by Andrée Starå