-
Link an individual task?
I've tried searching for this and haven't found info - I apologize if it's out there! Is it possible to send a link to an individual task? Sometimes, that's helpful. Since I group all relevant info into individual tasks on the card (e.g., attachments, links, and any conversation), it's sometimes really great to send a link…
-
Quickly Navigate Back to Smartsheet from WorkApps
Hi Community, Did you get tired of having to open a separate browser tab when you wanted to return to Smartsheet from a WorkApp? We sure did, well not anymore! Our latest update allows users to seamlessly navigate from WorkApps back to their work in Smartsheet with just one click by selecting the Smartsheet icon on the…
-
Actionable meeting summaries
Hi everyone. I got a question and would like to learn from your experience: Any examples of how you use Smartsheets to write actionable meeting summaries? Here's what I have in mind My goals: Creating a "Meeting Summary Area" for each project, that will include all meeting summaries. Summaries must be concise and…
-
Creating Project Timeline Visualizations-Not Gantt View
I am wondering if anyone has experience with creating a high-level project timeline view to put on a dashboard--and I am not talking about a Gantt view. What I am trying to do is avoid my customer from having to continue producing PowerPoint slides manually of the data they are managing in Smartsheet. Ideally, they would…
-
Formula for Milestone Health
I'm trying to figure out a formula for "Site Health". Each site has 9 milestones that will have a "Milestone Health" column. Each milestone must be completed a certain number of days before the project end date (October 31-22). I don't know how to create a formula to make the milestone health Green, Yellow and Red. At the…
-
INDEX/COLLECT Giving #INVALID VALUE
I have a sheet set up with a form for employees to enter their name, hours, and week ending date on a weekly basis. In order to create a dashboard chart to compare all employee's hours week-to-week, I've set up a separate sheet to reference the entry sheet with the week ending dates as the primary column and employee names…
-
Keyboard shortcut to insert a new comment
Hi Does anyone know how to open the New Comment dialog using the keyboard? it's becoming more and more difficult for me to take the mouse EXACTLY at the same point and click, in order to add a comment to the currently active row. We sometimes enter comments to update the status of numerous tasks, and this mouse-based…
-
Automatically linking different sheets to a master sheet?
Hi, I am trying to create a master sheet with information I need that pulls specific cell data from multiple different project sheets. I know I can use vlookup's and reference another sheet within them but I'm wondering if there is any way to create a template or workflow so that when a new project is added to the projects…
-
Dynamically Updating Dashboard Using Forms
I currently have a form sending data to a sheet, and then data from that first row displaying on a dashboard that I can print out for a visual representation of project data. Is there anyway that I can choose which row of data I want to show on the dashboard (aka choose which project I would like to visually see)? Thank…
-
Can I hide predecessor lines in a gantt chart?
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but the predecessor lines? Thanks!