-
Sum Network days but if field is blank results show invalid data type
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 type" Current sum is =NETWORKDAYS([Quote Request Recieved]198, [Quote Sent Date]198) Can…
-
Looking to set Notifications/Reminders beyond the default options
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 months after date in cell, IF another cell has a certain value 9 years, 9 months after date…
-
Formula Help
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 The idea is if a task is due today or tomorrow its red, if a task is due within 3-5 days its…
-
Feature Request
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 will help grab Smartsheet Developers/Engineers attention. - "View As (Other User)"…
-
If cells in formula are blank, then leave the formula cell blank
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 date completed cell is empty. How can I do that? For some reason ISBLANK isn't working…
-
Weeks to go Formula
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 event date along each task item. Thanks!
-
Alerts and Actions not working
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 when it turns red, another one gets sent out. I've played around with this for a few days. I have…
-
Forms
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 area according to the date...thoughts??
-
Formula To mark a row as recent
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), "Recent", false) I'm working in a quotes sheet that can get very long and I want to create a…
-
Conditional sum formula
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 value, I want a sum of the values recorded against that type in column value. And I…