Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for March 2016
Discussion List
Images from Link to Other Sheet
Currently, when you double-click on an image that is linked from an inserted image on another sheet, SS opens the "Link" dialog. Wouldn't it be better if the larger image preview opened, like it would on the source sheet?
Linking Cell Values From a Cell With a Formula
I am trying to create a workaround using the cell linking function in order to avoid circular references. In the picture below, the Premium column contains formulas calculating the appropriate total. Is there a way to have the Bound Premium column show only the value from the Premium column without carrying over the…
automated email
i want to send a pre-formatted email to clients based on a change of condition. how do i do this?
Customize Metadata for Rollup Project Plan
Hi Community: I want to see if anyone would know the way how to customize the metadata for the rollup project plan. I would like to add more "columns" to allow filtering in the Portfolio Scorecard when my projects rolls up into the scorecard.
Counting Children
What formula do I use to get a count of sub tasks under a particular task Parent/Child?
Gantt Sheet - Linking Dates
How can I generate the sub dates on a Gantt sheet using the duration? I would like to be able to copy my project and the subdates automatically generate from the head date? This could be generated by the duration. For example If the Head start date is 1/3/2016 I would like the sub dates to auto generate from the duration…
Row Level reminders (over allocation)
Does anybody have experience with a report showing over allocated persons in a project? What I mean is when person A works in project X on day 1,2,3 and 4. And the same person A is working in project Y on day 2 and 4. In this situation person A is over allocated on two days: day 2 and 4. How to get this nicely reported in…
How can we leave resource views expanded all the time?
We are currently heavily using the resource view, but we find there is one downside, which seems minor at first. All the users are always minimized but we would love to see it expanded at all times to have a quick view of the projects they are assigned to. Even when we expand it, the moment we refresh the page it…
Sumif with child based on criteria of other column?
I'm needing to get the SUM amount of dollars from the "Budget" column if that row is a "1" in the Quarter column...the rows are children...please help?
using start and end time columns to calculate hours worked for a timesheet page
i am trying to track staff hours by having them complete a web form to auto submit their timesheets. i need to be able capture start and end times for any given day so i can check how many hours they have worked. any suggestions?