-
How To Turn Checkmarks Into Bar Graph
I have 20 inspection locations and a rotate employees to inspect them monthly. Assignments are due every third Wednesday of the month. I manually check assignments that are turned in and manually create a bar graph to show the percentages of assignments turned in that month. Is there a formula to automate monthly…
-
I am stuck in view mode but I have editor access level how can I be released from view mode and back to editing the sheet
Hello I share my sheet with a fellow member to add and do task to update this sheet they were editors to the sheet but something happen where now they can only view the sheet and can not in put any information to the sheet what I erase them from the group and updated the app but once he got access to the group again he…
-
Edit Access for Some, View Only for Most
I have a large master sheet that I do not want anyone to have access to except the small team of admins. Is there a way for everyone in a dept to see the projects their dept are involved in (this is defined by a column), but only the PM can make edits to it? Bonus points if we can sort by "Status" then by "Kick-Off Date".…
-
Click-Through Capabilities for Smartsheet Calendar
When publishing a calendar from the Smartsheet Calendar widget to a dashboard, users can still slick through to a calendar list via the header in the calendar. There should be a way to "lock" the calendar view to a published dashboard that prevents users from clicking-through to other areas. This "locked" calendar should…
-
👋 Hello from Kentucky! | IT & Manufacturing PM
The Professional Side: I’m a Project Manager in the Manufacturing sector, where precision and timing are the heartbeat of everything we do. My journey started in general project management, but I’ve found my true "geek gear" in the IT and Security space. I’ve made Smartsheet my "single source of truth" for keeping…
-
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…
-
Regaining Access to Data After Having to Reinstate Smartsheet Subscription
I do not use Smartsheet but am the admin for a company that uses it daily. We had a former employee cancel our company plan when the annual invoice inadvertently charged his credit card. We have since reinstated the plan; however, my colleagues are unable to access, edit, view or otherwise do anything with their data and…
-
Calendar App - Permissions
I understand that users have access to the calendar app calendar for a particular item if they have access to the source sheet or report. If I create a report that looks at two sheets and then give view access to a group that only has access to one of the 2 underlying sheets, they will only see the information from that…
-
I Want to Filter Based on a Status and Date
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
-
Portfolio‑Level Gantt View Enhancement to Display Multiple Milestones per Project Row
I would like to confirm whether the system supports rendering multiple date fields (approximately 5–6 date columns) from a dataset within a single row in the Gantt or Timeline visualisation. The requirement is to display several milestone dates—such as multiple Gate Review events—on the same horizontal timeline for each…