-
Formula & Conditional Formatting Update in Reports
I have several smartsheets that have formulas and conditional formatting. These smartsheets are pulled into a summary report. The formula's and conditonal formatting do not update when opening the report. Each sheet must be opened individually in order for the formula's and conditional formatting to update.
-
Webforms - Email advice
I like the fact that webforms can be set up with a notification to automatically send an email to a contact. When you complete the webform, it offers you the opportunity to have a copy sent to you. When the notification goes through to the contact (e.g. a manager), the format displayed in the email is a copy of that row of…
-
Messaging
Is there a way to message all the people I have as collaborators? I use this product for construction management and I would like the ability to send a message to all to if we've had a major update on the schedule.
-
Smartsheet Document Library
Has anyone at Smartsheet considered a document -folder/file library built into the platform? I want to allow sharing with an integrated document library so they can use these documents such as fillable PDF's/Word/Excel together with rows in the sheet. This is for a project management system- with a number of stakeholders.…
-
Avg of Parent not matching up to Avg of Children
Hello, I'm trying to roll-up % effort at the project level based on % effort entries at the task level. I'm using the formula avg(children()) at the highest level to get the roll-up total. As a check, I'm calculating the avg % effort at the highest parent level throughout the plan. I'm running into a situation where my…
-
SmartSheet Adoption
I am sharing with approximately 80 users and about 15% actually login and look at the dashboard, click on issues, risks and attachments - never mind download the attachments. Has anyone experienced this resistance to adoption before and if so, how did you overcome it? Thanks, Karen
-
Remove print range lines from Gant view
I have a sheet which uses a gant view. After I had exported it, I now see print range lines running vertically on the sheet. Is there any way to remove these? I have found that the export functions don't meet my needs and I would rather take a screen shot of the gant, but the lines don't look good. Thank you very much
-
Create Report that Queries Every Schedule
Is it possible to create a report that queries every schedule, even the schedules that I do not have sharing privileges? I thought I could possibly do this through the SysAdmin account, or use the SysAdmin account to add myself to view all schedules. I am trying to create a report that lists all schedule entries labeled…
-
Row ID
Hi, I would like to be able to return the Row ID of a given column - to use in the following formula: =ROWID(ANCESTORS([Task Name]1)) Which should return the row ID of the first ancestor (Parent) or the current row. If there is no ancestor, I assume it would then return null or 0 Does a function such as 'ROWID' or similar…
-
Smartsheet Sights - Minimizing views
We have 200 users using approximately 50 sheets and have found the view very cumbersome for the users to scroll through a list. We have created a smartsheet "site" (using the site feature) linked to other "sites" that emulates a web base design. Where we are currently stuck is that we are looking for a way to direct our…
