-
Connect associated columns
Hi, I work in construction. My line of work requires me to record data in dropdown down and numerical/text entries in several sections. I could have 4/5 sections like this, each with different dropdowns and text/number entries (3/4 columns). Currently I am shifting multiple columns one at a time to display the necessary…
-
Lookup Functionality
I want to allow users to simply type in a lookup criteria, and see one row for the response that gives them the information they need versus scrolling through an immense database. I have had to create multiple complex Smartsheets with formulae, and then overlay reports and a dashboard to mimic this functionality. I would…
-
External collaborators with expiration date
In bigger companies often external collaborators are invited for a project. Easy to achieve. For lots of projects with hundreds of internal and external collaborators it would be very helpful if an admin could either set an expiration date, or at least a reminder to check if a specific collaborator should be removed.
-
pull data from Resource Management directly into the linked sheet/sheet summary
Would like a way to connect the project summary data in RM (project budget, incurred hours, future scheduled hours, project budget (fees), incurred (fees), future scheduled (fees) (see screenshot) into the linked smarthsheet/ smartsheet's sheet summary field.
-
Ticket View: View both all records with focus on one
A view where you can see all of your rows, and choose one to expand and maximize while the rest stay in sight. Similar to a ZenDesk agent view.
-
Smartsheet Report in Gantt View to show bar chart for Baseline and Actual
Please add this setting in Report - Gantt View. Currently you can only select 1 Date Range Display (Baseline Dates or Actual Dates). Best if these were visible in Report -Gantt View to visualize the status of the project or specific task/activity. Thanks SPIPMO
-
Allow Document Mapping to be used across sheets
I have many reports that I map for generation that reside in different sheets. This requires me to map the reports for each sheet. If there was a general location, or a way to set as templates to use in any asset that would be such a time saver.
-
automatically add row number to dashboard reports
I'm fairly new to Smartsheet and I love it. However, it would be nice if the row number from the task sheet was automatically added to the dashboard reports (upcoming tasks, overdue tasks, etc.). The row number does show up in the workflow reminder emails, but not on the reports. I had to add a new column to the task sheet…
-
Controlled data: Create Rows but not Edit OR Edit Rows but not Create
prevent accidental edits and maintain data integrity by allow users to create but not edit fields. or to stop duplicate fields from being created, grant users the ability to edit but stop them from creating new ones.
-
Automatically Update Numbers in Countdown Formula
Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.