Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for April 2017
Discussion List
Activity Log - Is there a way to limit who sees it?
Is there a way to hide the activity log from users or limit the view? We make changes to Project Plans especially in the beginning where we don't want a client to see it. It could raise a lot of questions and concerns.
Deleted sheet error with each log in.
I recently deleted a sheet (also permanently from "Deleted Items" tabs) that was always the first tab upon opening Smartsheets. I considered it a "home" tab if you will. Now that the sheet is deleted, each time I log into Smartsheets I receive this error "The sheet you were trying to open has been deleted.". Once I click…
telephone integration
I've been asked if SS can integrate with a telephone system so that phone numbers in a sheet can be dialled directly from within SS? We use SS to track customer prospecting and to log any contact with potential customers. Being able to call directly and then to log the date/time etc as well as prompt follow up would be a…
Conditional Formatting: "Today is in-between Start Date and End Date"?
Hi all, I built a filter to show my tasks that are due today with a green highlight. However, it does not capture tasks that last across several days (see the different shades of green in the attached image - bright green is a "today" task, and the woodland green is default). How can I extend my conditional formatting to…
Status automated e-mails no longer?
I just noticed that I am no longer receiving the automated emails on Smartsheet status. When I try to request them again, only a dump of RSS or Atom feed is available. Has this feature been removed?
Calculate duration excluding Weekends
Afternoon, I have a smartsheet where I have a start/received date and a sold/end date. I calculate the difference to determine the duration however I need to exclude Sat & Sun (Friday if possible) in the formula and thoughts? =NETDAYS([Date Received from xxx]263, [xxx Date Shipped Out]263)
Pre-select certain rows for export to PDF
Community: I run a regular export of a Gantt chart to PDF, and select pertinent rows to include in said report. I do this daily, and currently, have to go in and manually Ctrl-Click to select the same rows over and over... I know I can make these rows at a high level, and then collapse the items below, but the way the plan…
How do I create the Annual Manager Evaluation Form?
It can be found at this link: https://www.smartsheet.com/free-employee-performance-review-templates I've searched through Templates and don't see it.
Date-based RYGB balls automation
Hi, For the past couple of days, I have been trying to automate my RYGB balls based on Target End Date and Actual End Date columns. I've been reading this article, but I cannot seem to get the formula right. These are the conditions I am trying to satisfy: * BLUE = if the Target End Date cell and Actual End Date cell are…
Assign a task to more than one person?
Is there a way to assign more than one person to a task without having to create a whole new separate row or splitting the task into multiple tasks? It seems a bit messy to do so if I have a lot of tasks that will need multiple resources.
