Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.

Discussion List

  • Expected Progress
    In Formulas and Functions
    Hi, which formula can I use to calculate the expected Progress (depending on the current date)? Thanks
    253 4
    253 views 4 comments Most recent by PamelaH
  • Nested IF , logical operator (AND)
    In Formulas and Functions
    Hi All, I am trying to build a formula with IF, AND conditions but i am unsuccessful, can any one help me to sort out this please.  Here is the forumula =IF(AND([Position at Practice]227 = "Receptionist", [Current MECA Step]22…
    172 5
    172 views 5 comments Most recent by Andrée Starå
  • % Complete range in If statement how best to describe
    In Formulas and Functions
    I'm trying to have a conditional format occur in a status column, when the % Complete column hits a certain condition, for example: 1.  If % Complete = 100%, place "Complete" in the Status Column, and conditional format will cha…
    61 1
    61 views 1 comment Most recent by Andrée Starå
  • Dynamic Future Date based on Condition
    In Formulas and Functions
    Hello,  Issue: I need to create a date column that will produce a forecasted date, based on a manually entered date plus X amount of days, based on a certain value (phase). Example:  If Phase is "SOW Draft/Negotiations", add 60…
    11 1
    11 views 1 comment Most recent by Paul Newcome
  • Completed Row Drops To Bottom
    In Formulas and Functions
    Hi everyone,   While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on? 
    11 3
    11 views 3 comments Most recent by Andrée Starå
  • Formula help or advice if possible
    In Formulas and Functions
    Hi, i am hoping some can help or confirm if this is possible. The background: We are capturing data from employees working at 400+ locations. this is being done by a form. the data captured on the form is then being pushed out to individu…
    1 2
    1 view 2 comments Most recent by dave.mcpherson56751
  • MAXIFs Alternative?
    In Formulas and Functions
    I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then in the material price columns I have an…
    605 4
    605 views 4 comments Most recent by Paul Newcome
  • How to use "Countif" with reference to CHILDREN in another sheet
    In Formulas and Functions
    Hello - I need some help with the children formula.  I am trying to reference another sheet and only pull info from the children of specific hierarchies. The only way that I can do it, as of now and with my current skill set, is if I sele…
    31 2
    31 views 2 comments Most recent by Paul Newcome
  • Pipedrive + Smartsheets
    In Formulas and Functions
    When a deal in my pipedrive reaches a new stage 'Job Scheduled' it automatically adds a new row to Smart Sheets with a Task Name and Duration. What I need Smartsheets to do next is automatically enter a starting and end date based off of t…
    173 1
    173 views 1 comment Most recent by Andrée Starå
  • Formula Between Date
    In Formulas and Functions
    Can someone tell me what I am doing wrong in this formula? =COUNTIFS({HITRUST CAP Milestone Plan v2 - EIS & Sec Range 3}"remediated") AND({HITRUST CAP Milestone Plan v2 - EIS & Sec Range 4}<=(2018,6,30),>=(2018,4,1…
    2 1
    2 views 1 comment Most recent by Sterling