-
Removing the "Comments" tab from exported Excel reports
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called…
-
Removing the "Comments" tab from Reports
Hello, everyone! Automated Reports that export as an Excel file attachment come with the report on one worksheet tab and a second worksheet tab called "Comments." I don't need the "Comments" worksheet, but there is no setting to remove it. Can we add that as a setting?
-
Change "end date" based on status changes
When an end date is used in a dependency setting, you can't use automation or formulas to change it. However, this is when it is critical (pun fully intended)! When someone marks an item as Completed status, it would be helpful if the sheet could update the End Date column to the date it marked completed. For dependencies…
-
Change "End Date" based on status change?
Hello, all! Is it possible to change the "End Date" column based on when someone completes a task? Sometimes my team finishes a task on time. Sometimes it's a few days late. Sometimes (like today), a person finishes nearly a week early! Of course, if the end date is off, that messes with all successor tasks. We're doing a…
-
Fix Formatting for Line Breaks in Generated Documents
Hello, all! I have a problem that isn't unique to me, but it is certainly frustrating. When I have line breaks in a generated document, whatever formatting I have in my fillable PDF does not hold. The formatting works for single- yet not multi-line text. Can we please fix this issue? I've noticed that several others have…
-
Change status of a child row based on parent row
Hello, all! Is there a way to change all the statuses for child rows based on a parent row? Let's say I have a project to grow an orchard (parent row). It would have subtasks, like buying saplings, procuring fertilizer, and creating a watering schedule (child rows). If I have to scrap the orchard project, I'd mark it as…
-
Saying hello 👋🏻
Hello, everyone! I'm Amber, an academic librarian. I function as the project manager for our team, and I fell in love with Smartsheet when I was introduced to this application in 2020. I live in West Virginia with my husband Johnny and our menagerie of five cats and one dog. I love using the Community forums to find…
-
Default to open a specific folder when selecting "Browse"
Most of my work in Smartsheet is in a shared Workspace. I would like to open by default to this folder every time I click the Browse icon in Smartsheet rather than defaulting to my Sheets. I know I can Favorite/Bookmark this folder in my Browser, but if I'm already in a sheet and click Browse, it isn't seamless. Is this…
-
Combining IF and COUNTM?
Hello, all! I need to count items in a multiple option column, but only within a certain date range. If this were a single selection, I would use COUNTIFS, but this is different. Do you have advice on how to do this? I appreciate any guidance you can offer!
-
Delete multiple comments?
Hello, all! We created a copy of a 2020 sheet to make a new one for 2021 because so many of the tasks are recurring; we're merely updating assignees and task dates in most cases. However, we're now left with several comments and attachments throughout the sheet that we need to delete because we copied the full sheet. Is it…