-
How do the hours work in the “Report time for something else” feature?
I've been trying to use the “Report time for something else” feature in Resource Management, under the Time & Expenses tab. However, even when I assign hours to a project and those hours are approved by the approver, no task appears in the Schedule tab. How do these hours work? Do they only affect reports? Where can I view…
-
Identifying Sheet/Report Dependencies Across a Workspace
Hello, Is there a way to identify the dependencies of a sheet or report across a workspace? Specifically, I’d like to see which reports rely on a given sheet and whether those reports feed into dashboards. I’m not referring to usage metrics such as views, but rather how assets are interconnected. Thank you!
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
When updating any setting for recurring email or update requests prevent "This date and time must be in the future error" for start date
It would be nice to not have Smartsheet do a full validation check on all fields for existing scheduled recurring emails or update requests. It is nice to have the historical value of the original start date for the recurring task, and an annoyance to have to change the start date to next day when just updating the end…
-
Need to find the whether the task done on time or not with DATE + TIME Functions
3 Teams handle this Deadline, 1 day each. Total Deadline 3 Days. Each day 24 hrs deadline. Ex: Received Date/Time 06/08/26 7 PM to Due Date/ Time 06/11/26 7 PM. ( 7 PM is not fixed irrespective of time, but we need 3 working days as deadline not 7 days - Mon to Fri) 1 Scenario: Team 1 If Received Date/Time has text value…
-
Could you please confirm whether column headers can be aligned in reports?
Could you please confirm whether column headers can be aligned in reports?
-
Send Dashboard via email - manually and automated workflow
My idea is to create functionality to be able to send a dashboard snapshot via email from within Smartsheet, both manually and via an automated workflow. Ideally using an HTML format so any links in the dashboard are links in the email. Smartsheet Dashboards are fantastic and we use them heavily with our project teams and…
-
Incremental Baselines & Dynamic Baseline Linking
Problem: Current Limitations Destructive Updates: Currently, snapping a baseline is a global action for the entire sheet. There is no way to baseline newly added scope (new tasks) without overwriting and erasing the historical variance data of the existing tasks. Manual Data Entry: Users are forced to manually copy/paste…
-
Edit recipients in scheduled email reports
I have many reports that get emailed out on a defined schedule and often the recipients need edited. Unfortunately editing recipients is not an option (only editing the recurrence schedule), so I have to recreate the entire schedule to remove or add any recipients. It is very tedious and time consuming when you have…