-
New Proofing Issues
We use to be able to copy an edit from the proofing to paste that edit into an original working document but that doesn't seem to work anymore. For example: We send a manual out to get proofed by an engineer. That engineering will rewrite a sentence on the proof. The designer would then copy the sentence from the proof and…
-
Blank spreadsheet
A file was shared with me (with limited permissions), the owner set a filter to limit what can be seen of the file. However, when I go to view the spreadsheet I only see blank cells. I have no way of turning off the filter. What am I doing wrong?
-
Tasks on At Risk and Milestones Reports
Hello! When using reports such as At Risk and Milestones, the appropriate Tasks surface however not their corresponding Parent Phase/Category. So for the projects I work on, it is not helpful to see Tasks without that Parent. Does anyone have a method or workaround to make the Parent surface on the report with the Tasks?…
-
Tips for creating a master resourcing sheet
I have 2 different smartsheets that are pulling data from one more detailed spreadsheet for project resource management. Is there a way to connect the sheets so I don't have to manually make changes to each?
-
Sum in report in chart
Hi! I need to make a chart of two results. Collecting data from multiple sheets via a report. I include all the sheets needed, and then make groups for the two different items. As shown in the picture below, "Timer brukt" sums up to 602,5 and "Timer kalkulert" sums up to 1104,7. How can I get these two together in one…
-
Import excel file to existing SM
Hi All, Im starting my journey with the Smartsheet. I wonder if you can advise. What I want to achieve. Export data from SM to Excel file. Change existing data, add maybe new rows, etc. Then import Excel file to the same SM to be able to update the data at the end in SM. I want f course keep the Sheet ID. Currently when im…
-
Report from multiple sheets
Hi, Can anyone suggest me how to retrieve data from 2 sheets into a report? Here is the list of fields from sheet1 and sheet2 Sheet1: program, task name, release name, field4, field5... Sheet2: program, release name, field3, field4,field5.... Program and release name is the common from both the sheets. Sheet1 has main and…
-
Automated reminder email to view a dashboard?
Is it possible to automate a periodic reminder email from within Smartsheet to go out to a project team or project stakeholders to view a dashboard to get the latest project status? The email should include either a link direct to the dashboard, or the dashboard as an attachment. Thanks!
-
Documentation edit requests
Curious if anyone out there has created something for team members to submit edits or changes for upcoming catalogs, technical manuals, product brochures. For example, we have a new Widget sized B, it needs to be added to the Catalog and to the Tech Manual. I want to create a tool all of our team can use so that proposed…
-
Scheduling Emails Twice a day
Under send as attachment, you can schedule your sheet to be emailed to a specific group of people daily but I am in need of sending it twice a day. Is there a way to do this?
