-
Can color codes in Smartsheet export to a Google calendar?
I have three status listings for my projects in Smartsheet - not yet started, under development and completed. Each one is color-coded differently (red, yellow and green). I also have exported my tasks to a Google calendar but all the items appear in the calendar in the same color. Is there some way of exporting different…
-
how to create a formula that will return the years of service for an Employee
I need a basic formula that will take the employees start date and todays date to calculate years of service?
-
Getting alerts when a new row is added to a sheet..?
Hi all, I'm trying to figure out how to get an alert when a new row is added to a sheet. I use Zapier to pull data from Pipeline Deals, which adds a row that I then edit as needed. What I was trying to do is get the sheet to notify me when one of those fields that are ALWAYS populated when Zapier pulls the info into…
-
Flexibly managing resources for assignment - by logical project groups
a - We manage a constantly evolving list of projects, with each project being managed by 1-3 Smartsheet Users (our PMs), and tasks being assigned to one of the 15-45 resources (people, -vendors, managers in the customer's company (not users). b - The list of contacts is unique to each project c - The 1-3 PMs need to be…
-
Sights: Revision Control/Tracking History
I am attempting to migrate & automate parts of my company's business process of creating and updating weekly, project slide updates to incorporate Sights (since we use underlying sheets for project tracking). Are there any best practices, solutions, or workarounds for revision control of Smartsheet Sights? I was hoping…
-
Automatic email notification link when comments change or are added
The automatic email notifications based on the comments changing is nice, but the link in the automatic email notification does not take the user to the specific comment that was added or even the row it was added. It requires the user to go back to the email to look and see what row the comment was added to. This is…
-
Critical Path View for Viewers
Is there a way to allow people with viewer access to a sheet to see the critical path on the gantt view? The project team would like to be able to view the critical path but not allow every person to have edit rights on the sheet. Any advice is appreciated!
-
Unable to insert a trailing space
I would like the content of a cell have one or more trailing spaces like "test text ", but the UI seems to automatically strip out trailing spaces before saving. Any advice on hos I can retain trailing spaces is much appreciated!
-
Gantt Chart - Duration changing Start/End dates incorrectly
Hello, I am having an issue when in Gantt chart mode. If I have a start date set, and change the duration to be 2 days, the end date is automatically adjusting to be three days from the start date, even though the duration is still correctly listed at 2. This only occurs over weekends and works properly over weekdays so I…
-
Folder name
Is there anyway to see the folder name when we load SQL? We can see the workspace but not the child folder! Thanks