-
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…
-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
Adding to an Existing Conditional Formula: Date Field
Good Day All: I am trying to add to my existing formula if the date is not populated the harvey ball will remain yellow. If all conditions are met (date submitted, date approved, approved by committee, and Delivery date) then green All help greatly appreciated, Thanks! Existing Formula: =IF([Approved by Committee]2 = 1,…
