-
Report for yesterday
Hello, I hope someone can help me. Maybe I'm blind, but I can't find a way to make a Report for only yesterday, I work on a big sheet (> 4,000 rows, 25 columns) with many different days in the column [Datum]. Now I want to make a report, that shows only the rows from yesterday. Not today, not further in the past. I want to…
-
Project Management and Stakeholder Logs
We're using smartsheet to track a land acquisition project for a utility. Each row will contain a contact, parcel features, a dates of progress. We need a way to manage daily communication and updates. We have considered using comments and a remarks column. Is there a better solution? Thanks!
-
Meeting agenda item reports
We're piloting the use of the template set including the past & future agenda item reports. The issue is the reports aren't pulling the correct data. I added a column to the meeting sheet that is the meeting date (function pulls it in date format from the parent row where the date is entered as text) so each child row is…
-
How to remove "Fill out forms with the Smartsheet app" from top of form?
I created a form, and emailed the form link to several persons. I want the persons to simply click on the form link, which will open the form, then complete and submit the form. To keep the process simple, the persons do not have the Smartsheet app. When the person clicks on the link, at the top of the form the user will…
-
How to build analytics for dashboard on a data sheet?
I had a couple of analytics columns on a dashboard that were locked and hidden, where I had a bunch of COUNTIF(S)s and SUMs (as a workaround without pivot tables) to create some charts for my dashboard. Turns out that when people change the sort, these analytics columns got messed up, and now my data is all over the place…
-
Cell link indicator
Hi everyone, Is there away to hide the cell link triangle indicators? Most of my cells are linked and it obscures the data. Thank you
-
Report on Resource Utilization on a Single Day
I have a project plan that was created by importing a plan from Project. I would like to create a report that shows the resources and their utilization on a single day. The only filter I see in the Report Builder is to filter on the Start Date or the End Date of a task. I want to see anyone who has tasks that occur on a…
-
Printing and including Workspace on PDF
Our company rolls out many Workspaces which reflect individual projects. We provide copies of project Sheets in a printed PDF format for our clients - the Sheets reside in each project Workspace. When printing, the Sheet name is included - via the checkbox (per attached). It's quite oversized. (I've attached an example…
-
RGY Balls and Days remaining
Currently, I am using this formula =IF([End Date]396 < TODAY(), "Red", IF([End Date]396 = TODAY(), "Yellow", IF([End Date]396 > TODAY(), "Green"))) for health status. What I would like to do is tweak this, so that if a task is less than 75%, and due in 3 days, the ball is YELLOW. Everything else remains the same
-
Automate Notification
I am trying to find a way to use the DONE checkbox to then notify the dependent task assignment that it is ready to launch. I have looked for solutions and come up with the idea of having a handoff column, but then that is just putting the same information twice in the sheet. What I am wondering is if there is a way to…
