Formulas and Functions

Archives for January 2018

Discussion List

  • 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…
    42 views 1 comment Most recent by [email protected] Formulas and Functions
  • Looking to set Notifications/Reminders beyond the default options
    In Formulas and Functions
    Hello - I'm a bit new to Smartsheet but loving it so far.  I have a few columns with dates that I would like email notifications or reminders set up when the following conditions occur: 1 year anniversary from date in cell 5 years, 9 mon…
    11 4
    11 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • 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…
    61 9
    61 views 9 comments Most recent by Mike Wilday Formulas and Functions
  • Feature Request
    In Formulas and Functions
    I have used Smartsheet for years and find it to be the best Project Management platform to date. I have a few features I'd like to suggest be added in the near future... please note if you'd find any of these helpful too. Hopefully this w…
    353 views 1 comment Most recent by Shaine Greenwood Formulas and Functions
  • If cells in formula are blank, then leave the formula cell blank
    In Formulas and Functions
    I have three main columns: Planned Start Date, Planned End Date, and Date Completed I am utilizing the formula below to determine which tasks are done and late in the status column. I would also like the status cell to be empty if the dat…
    252 1
    252 views 1 comment Most recent by rjudenberg Formulas and Functions
  • Weeks to go Formula
    In Formulas and Functions
    Apologies if this exists somewhere - I tried to look but couldn't find exactly what I needed.   Using smartsheet to project manage for an event - I am wanting to have a 'Weeks to Go' Column that counts down how many weeks until the exact…
    184 6
    184 views 6 comments Most recent by Andrée Starå Formulas and Functions
  • Alerts and Actions not working
    In Formulas and Functions
    Hi,  I have a sheet where the RYGG is automated based on the due date (overdue=red, due date +2=yellow, the rest=green). I then set up the alerts ("Send a notification") so when the status turns yellow one email goes out, and wh…
    171 10
    171 views 10 comments Most recent by Andrée Starå Formulas and Functions
  • Forms
    In Formulas and Functions
    I need data to land in particular areas when entering into a Form... In my sheet I have Hierarchy's...Months, Jan through December. Under those sections I need the orders that are entered into a form to automatically be put under each are…
    102 views 5 comments Most recent by Mike Wilday Formulas and Functions
  • Formula To mark a row as recent
    In Formulas and Functions
    Hello,  I would like to type the word recent into a cell based on it being recent(created date is in the last 7/ days). Otherwise I want the Cell to be blank.  This is what I tried but get  #UNPARSEABLE =IF([Created]246>=TODAY(-7), …
    11 4
    11 views 4 comments Most recent by Deirdre Formulas and Functions
  • Conditional sum formula
    In Formulas and Functions
    Please be gentle, very novice smartsheet user! I am trying to get a total value on a smart sheet when certain conditions are met. I have a column called Type and a column called value, so when cell entries in column type are a particular…
    192 views 3 comments Most recent by Andrée Starå Formulas and Functions