Formulas and Functions

Archives for July 2018

Discussion List

  • Stale time/date
    In Formulas and Functions
    Hi, I am trying to setup a "Stale" notification for a help ticketing system.  When a support ticket (row) ticket has not been modified when compared to the current time and date in over an X amount of hours, then send a notifica…
    11 7
    11 views 7 comments Most recent by Marcus Lintault Formulas and Functions
  • Manual Copy and Paste of rows fails to paste formulas and hierarchy
    In Formulas and Functions
    About 3 weeks ago I began being unable to copy and paste multiple rows between sheets in smartsheet. I have about 12 rows with several columns that match columns in a separate sheet. I am trying to copy rows from one sheet manually using C…
    153 2
    153 views 2 comments Most recent by Mike Wilday Formulas and Functions
  • index match formula not working
    In Formulas and Functions
    Hi, I am using the below index match formula which is not working. The MFG Rev 18 area range is a "contact list" column type, and the column used for the formula is a Text type.   I assume the formula is not working due to the ty…
    325 5
    325 views 5 comments Most recent by J. Craig Williams Formulas and Functions
  • Need Help With "VLOOKUP"
    In Formulas and Functions
    I would like some help trying to figure out a "VLOOKUP" formula. I am trying to get the circled number on the attached file to go onto another sheet. I have tried all different ways and I cannot seem to get it to work. Please hel…
    2 8
    2 views 8 comments Most recent by Andrée Starå Formulas and Functions
  • Write Function that has 2 check boxes in it?
    In Formulas and Functions
    Hi everyone, I have had smartsheet for awhile and finally taking the time to learn/use it and am stuck. I have a custom apparel business and have made a sheet to keep track of all my orders and what the cost will be. I have columns for Qu…
    11 3
    11 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Average of duration
    In Formulas and Functions
    Hi, does anyone know if it is possible to calculate the average of data in a column displaying a duration? They are expressed as 3d, 5d, etc. and therefore it won't let me calculate the average as it doesn't seem to recognize them as numb…
    165 8
    165 views 8 comments Most recent by Andrée Starå Formulas and Functions
  • Sending Multiple lines for Approval at one time
    In Formulas and Functions
    Hi, has anyone figured out a way to send an approval request for more than one row at a time?  I have rows that all need approved that need to be sent in the approval request along with their information, much like a daily notification of …
    592 9
    592 views 9 comments Most recent by Andrée Starå Formulas and Functions
  • Multiple IF / AND / OR Statements Help, Please.
    In Formulas and Functions
    This is such a great community and a wealth of knowledge for a new Smartsheet user like me. I have done several formulas, but this one has me scratching my head.  I have a [Target Date] column, [% Complete] column, and status column that …
    3919 7
    3.9K views 7 comments Most recent by J. Craig Williams Formulas and Functions
  • Project Team Resource Allocation
    In Formulas and Functions
    Hi,   Can anyone share how they're tracking their teams resources? The resource allocation is great however, it only allows me to show one team member not multiple per task. In addition, I'd need this information for executive reporting …
    11 2
    11 views 2 comments Most recent by Andrée Starå Formulas and Functions
  • Multiple IF Statements
    In Formulas and Functions
    Can we do multiple IF statements? I've tried to use IF and also OR to complete the function I'm trying to do and nothing seems to work. I want my Status column, "Not Started", "In Progress", and "Completed" to…
    10597 10
    10.6K views 10 comments Most recent by Hardik Ranpara Formulas and Functions