-
Issue with Duration/Date Range not rolling up
Hi everyone, I have a puzzle. I have a sheet that is all working except for this one spot, and it's affecting the rest of the sheet. I can't figure out what's wrong. The parent task will not display the end date or total duration for its section. Dependencies are enabled on the sheet. This screenshot shows the whole…
-
Notification Center acting funny, anyone else?
My company recently added Mimecase for our spam filter and, after working through the notifications not sending and getting that fixed- I found my alerts are not clearing when I open the automated emails I'm cc'd on. Previously, the alerts noted in the Notification Center cleared automatically when I opened the same…
-
Used Save as New to Open a new Project Sheet - Contact List not functioning right
I used Save as New to copy a project sheet to a new project with the same individuals on the project team. On the new sheet, the contact list isn't fully populated, and for some contacts, the name is greyed out so I'm unable to edit it. Also we're unable to use @comments to easily message the team. What am i missing?
-
disable export & share but not see
I have to share a sheet with people so that data that is relevant to them will display on their dashboard. I want them to view only the dashboard content but not truly have access to the sheet itself that houses other peoples data. Also, is there a way to disable the ability to export? If a person can export and I am…
-
Can I make this use case work in Smartsheet?
Hi, I've been trying to solution a use case, and I'm curious if we can do it in Smartsheet. The use case is ordering materials for individual restaurants based on specific criteria. I was thinking that I can set up one sheet with the restaurant specific information (name, address, city, other required criteria), and a…
-
Problems creating a chart for quarterly metrics
Hope everyone is enjoying their day! I would appreciate any assistance with my issue. This is report that needs to be charted: Here is how the chart comes out: How do I get it to show actual quarters and their numbers? Thank you in advance for your time and effort.
-
Link or Attach Google Drive file/asset in column
Is it possible to link to Google Drive files and have them appear in a designated column? I see that you can attach them to rows, but they don't really "appear" anywhere other than the little icon at the beginning of each row. For example, I want to have an "assets" column on my sheet and have all related files from my…
-
Alert Someone Automation Workflow
Hi, I have column in a sheet named "Interests" with a dropdown with multi-select. So based on this dropdown, I'm looking to creating a workflow, to send automated email alerts (based on dropdown selection), however I am not able to select the dropdown values within the automation as shown below in the screenshot. I wanted…
-
Conditional formatting change status with colors
I want to change the status and the cell will change of color (red, green, etc) depending on the status. The sheet that I am working on doesn't have that possibility in the column settings.? see the image below. can you help me with that?
-
How do I report on the Intake Submission Date field from the Project Intake Sheet?
Hi, I'm using the PMO template. The "Intake Submission Date" column is system generated in the "Project Intake Sheet". Is there a way to pull this column into a report? When I create a report using the Project Intake Sheet, the Intake Submission Date does not show up as a field that I can select. Project Intake Sheet and…