-
How would you measure progress by quarter
Hi there, I am hoping to crowdsource some creative answers to a question that has been asked of me by my leadership team. I currently have a Project Management Office/Organization set up in Smartsheet where projects come in with a request form and are managed on an intake sheet, get their own project planning grid &…
-
Can Bridge get data from Admin > Groups?
Is there a known or suggested method or Bridge workflow I may use to record data from Admin Center > Groups to a Smartsheet? I want a workflow to look up the groups in our plan's Admin Center and replace the rows of a sheet and column on a daily recurrence.
-
Can I combine multiple rows into one row on a Gantt Chart?
Dear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows. Is there any method to combine multiple rows into one row and use one row to present…
-
Using Multiple Forms to Update a Single Row
Is there a way to use multiple forms to feed into a single row? An example would be our orthopedics program. Our coordinator collects several pieces of information from multiple departments (OR, Pre-Surgical, Med/Surg Nursing Floor, Education, etc.) Can I build something so she can create a row per patient with their ID…
-
Linked Sheets/Copied Rows
I created an automation that copies a row from one sheet to another based on certain conditions. What I am curious about is if there is a way to have information flow back to the originating sheet if changes are made in the 'linked to' sheet. Currently, I can only get the row information to flow one way and I'd like it to…
-
Sheet Help
Hello everyone, I am not sure if this is possible but I am trying to manage a project that involves multiple color approvals for a singular item but lots of different items within the project. Can someone take a look at the attachment and tell me if something like this is possible? I understand the basics of the…
-
Freezing top row OR colour the header row
Am I able to freeze row 1 on a sheet so when people fill out the form, the data imports underneath row one? OR Can I change the colours of the header row like I have with row 1?
-
Do not add 10 blank rows at the bottom of the sheet
Please STOP adding blank rows to the bottom of the sheet. They are unnecessary and can cause issues with formulas.
-
How to get report to show up in sheets folder?
Hello all, I have a Smartsheet report that I can access from the home area or if I click the link directly. However, when I go to sheets, it is not showing up. In the second image, you can see there are no reports, only sheets. Is there a reason that the report is not showing up in the sheets folder? Does it take a few…
-
Data mapping for documentation
As we've been increasing our implementation across all of our departments, the need for documentation is growing. I think it would be nice to have a utility that would generate either a graphic map, or spreadsheet; that show all cross-sheet references, automations, cross-cell references, etc. This would help in creating…