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

  • Criteria for Alerts and Actions Rule
    In Formulas and Functions
    My boss has a Smartsheet set up to send a Update Request 30 days before today.  For example row 7 would look like ....=[Due_Date]7 - TODAY() Would this alert still be sent if Smartsheet was down for maintenance at the scheduled time the a…
    13 1
    13 views 1 comment Most recent by Mike Wilday
  • Formula Help
    In Formulas and Functions
    Hello New user needing help with formula. I would like it to be something like this: When the due date is => than today -1 turn red, if the due date is < today - 3 days turn yellow, if due date is is =. than today +5 turn green T…
    100 9
    100 views 9 comments Most recent by Mike Wilday
  • Column Status Formula
    In Formulas and Functions
    Hi Everyone,  I have a status column with the following options: Not Started, In-progress, Complete, N/A. I've created a formula if the parent row is set at 'Not Started' then the sub-task would automatically change to 'Not Started'.  Sa…
    36 1
    36 views 1 comment Most recent by aguillot
  • Parent Sum IF
    In Formulas and Functions
    I've tried a variety of calculations, and can't seem to get the results I'm seeking.  I'm simply trying to add up all of the parent rows in a column called Resource Days that are Assigned To a specific team member.  Any suggestions? =SUMI…
    232 1
    232 views 1 comment Most recent by J. Craig Williams
  • Enhancement Request: Report Criteria What? on Dropdown column like Text/Number
    In Formulas and Functions
    When I have a Dropdown column for the What? criteria of a Report, my only option is some version of the "is one of" criteria. What I want is to be able to build the criteria like a Text/Number column, for example using "con…
    57 1
    57 views 1 comment Most recent by Shaine Greenwood
  • Count & AVG only if another column contains "text"
    In Formulas and Functions
    Hi Again, After scouring discussion boards I have managed to Average the total of the rows, see below =IF((COUNT([Days to respond]194:[Days to respond]214)) = (COUNTIF([Days to respond]194:[Days to respond]214, 0)), 0, SUM([Days to respo…
    37 2
    37 views 2 comments Most recent by J. Craig Williams
  • Saving original cell value in another cell
    In Formulas and Functions
    I have a cell that holds a target date (Target Go-Live Date) and another cell that I want to hold the original date entered in the target date cell.  This way if the Target Go-Live Date is changed, the other cell (Original Target Date) has…
    79 2
    79 views 2 comments Most recent by J. Craig Williams
  • Help with nested IF statement using AND
    In Formulas and Functions
    Hello Community, I have created the below formula that SEEMS to be working but is not showing up with the color coding that typically happens when you have all your formula ducks in a row.  It is returning a result, not an error, but I’m …
    14 3
    14 views 3 comments Most recent by Katie Williams
  • IF statement with AND/OR
    In Formulas and Functions
    I am trying to create a formula that calculates Days Overdue based on varying approval levels.  I need it to calculate if Direct Manager Approval is "Submitted" and Hiring Manager/Director Approval is blank OR if Direct Manager A…
    13 6
    13 views 6 comments Most recent by Katie Williams
  • Sum Network days but if field is blank results show invalid data type
    In Formulas and Functions
    The subject pretty well tells it all, I am trying to sum the network days between the request received and request sent date but if we haven't sent the request response as yet the field is empty and shows the error " Invalid data typ…
    60 1
    60 views 1 comment Most recent by [email protected]