-
Send as attachment - PDF + Excel ?
Hi Guys Another day another Smartsheet query - is it possible when sending a report as a scheduled attachment to send both the PDF & the Excel in the same email? Or is there a workaround in order to do so? Thanks! :)
-
End Date is auto-filled, how to stop?
Hi All, I have created a sheet for my team and outside of normal columns, we have an extra "Target End Date" to track if we meet target or not. Please see picture. However, the Actual End Date is auto-filled every time I enter Start Date with the default value of the same day as Start Date. It is very inconvenient, I am…
-
Converting a formula to a "column formula"
I am trying to convert this formula into a column formula. It takes selected cells from a row to populate the overall "Status" column. If tasks are "Not Started", the overall status will be "Not Started". The Same would apply for Cancelled. If all tasks are complete, cancelled or n/a, the overall status would be "n/a". If…
-
Activity Log
Is there a way to generate a report from the activity log? What I want to do is to be able to quantify actions being taken within a time frame (i.e.: one month of time). For example, I would like to be able to track how many lines were added to our master sheet - and how many were removed. I would also like to be able to…
-
Report Creation
Greetings, I am creating a report to check the incoming date of certain items for multiple projects. While creating it, only the parent row is getting imported to the report. Is it possible to incorporate the children rows as well ? The structure of my rows in the original sheets are as follows: Shipment of X for a…
-
Classroom Assignment
Hello, does anyone have or know of a solution for automatically assigning classroom space ? I have to build a sheet for the automatic assignment of classroom space referencing the registered number of students from another sheet, and keeping in mind the classroom space time availability so as not to overlap courses in the…
-
Formula for RYG for Project Schedule Status
We were able to create a formula for Green and Red status but have not figured out how we can automatically set the project status to YELLOW. Normally if an activity(s) are slipping that affects the critical path the project should be in a YELLOW state so a return to green plan can be worked on. So what I'm looking for is…
-
Multiple IFs then SUM
I have developed individual project sheets. In the project sheet I have multiple tasks. I want to populate number of hours I worked on each task, by summing the number of hours I worked on that project prior to a certain date. I keep all my hours worked on various projects in a work log which I am referencing from the…
-
Only want child task ranges in calendar view (start-end date) w/o summary task row ranges.
We have a large project management sheet with several levels of hierarchy and many summary rows and child rows. We want our staff to be able to use calendar view to easily visualize how their tasks lay out over the course of the month and where they may overlap. (i.e., staff can see where they may need to work on two…
-
Is it possible to edit a report from a dashboard?
Hi. We are creating a Smartsheet dashboard for our incoming projects. Each project manager will need to make comments to their respective projects. Is is possible, if we add the project report to our dashboard, that a PM can edit the report from the dashboard and have it save the edits? Thanks, Shawn
