Formulas and Functions
Archives for January 2018
Discussion List
-
Sum Network days but if field is blank results show invalid data typeIn Formulas and FunctionsThe 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…
-
Looking to set Notifications/Reminders beyond the default optionsIn Formulas and FunctionsHello - 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…
-
Formula HelpIn Formulas and FunctionsHello 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…
-
Feature RequestIn Formulas and FunctionsI 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…
-
If cells in formula are blank, then leave the formula cell blankIn Formulas and FunctionsI 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…
-
Weeks to go FormulaIn Formulas and FunctionsApologies 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…
-
Alerts and Actions not workingIn Formulas and FunctionsHi, 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…
-
FormsIn Formulas and FunctionsI 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…
-
Formula To mark a row as recentIn Formulas and FunctionsHello, 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), …
-
Conditional sum formulaIn Formulas and FunctionsPlease 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…