-
Dependencies and Predecessors
I am brand new to using Smartsheets and need help on creating multiple date dependencies. I want to track a myriad of tasks over time, ultimately based on a final event date. Each task has a different due date in realtionship to the final event date, and would thus have a different start date. The tracking document also…
-
Monday of date
I have an installation date column and a "week of" column. In our "week of" column, we keep the date of the Monday before. As an example, if the installation date is 1/19/17, the "Week of" column should be 1/16/17. Or, if the date is on a Monday, (Installation 1/23/17), the "Week of" column should be the same as the…
-
How to set calendar view permanently for a report
Hi, How can I set the calendar view permanently as a view for a report? And is it possible to display more on the calendar above the primary column?
-
Google Contacts Import
The Google Contacts import process needs some fine-tunning. For those of us that have several hundred or even thousands of contacts, we need a way to filter the import. A couple of suggestions: 1. By Google Group: this will allow us to select which group to import into SS. 2. By query: say I only want to import everyone in…
-
Use of one sheet as List for other Smartsheet
I am trying to select Project names in my action tracker smartsheet. The Project names has been maintained as separate Smartsheet. How to link Project name sheet as List in my action tracker sheet.
-
Using Gant chart in Powerpoint
I have a request to display the gant chart for a project within a powerpoint presentation. When I export the plan to an image, it appears pretty small and grainy. I would love to pick and choose some rows (I have already collapsed as many as I can) to display to see if the size would be better for the powerpoint slide but…
-
Conversion Formulas / Cell Linking
I am cell-linking 2 sheets but 1 sheet records time in days and allocation: Example: 2 days and 50% Allocation = total of 8 hours spent on the project over the course of 2 days. (The duration can not be changed from days because this is our project management sheet and we use in the gantt chart to share with customers.)…
-
Setting alerts in Smartsheet
Is it possible in Smartsheet to set alerts in the way that I will get a specific columns in email notification as I can do it when I send a raw to somebody? I don't want to see whole information from rows in my email notification but only specific one. Looking forward to hear from you.
-
Summarizing project KPI´s in symbols
Hi, does anyone experienced how to summarize project data (like deliverables, issues, status and so on) in symbols (RYG balls, arrows)? Do I need a formular for this? I´d like to summarize it to show them at our dashboard. I use symbols already but do not know how to summarize them automatically at the end of the column.…
-
Outlook on Premise
I know there are multiple comments about Outlook, but I want to make sure our need is known. We are due to renew our annual Team Subscription and the only complaint from management is that we can't integrate Smartsheet with Outlook. This is causing requirements to look for other options when our team does not want to…
