-
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…
-
Data missing when moving rows?
Hi there, Has anyone noticed an issue with data missing when moving a row from one sheet to another? I have an automation that moves older rows in one sheet to an archive sheet once a month. However, it appears that data in at least one of the columns is missing. Any ideas what might cause this? Thanks! Jackie
-
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…
-
Default Sort setting
Hi, How can I set a default for sorting in a sheet? For example, I have a system "Modified Date" column, and I want the sheet to ALWAYS sort by descending order, i.e. the most recently modified on top. I want the sort setting to stay even when refreshed, and when I'm editing in the sheet that the modified row will…
-
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?
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
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…
