Best Of
Re: Extract the 2nd name from 3 names when delimeted by ,
@Naeem Ejaz That will only work if the second name always starts a the 14th character and is always 11 characters long.
@Bruce Johnson Give this a try for something more dynamic:
=MID("," + [Column Name]@row + ",", FIND("~", SUBSTITUTE("," + [Column Name]@row + ",", ",", "~", 2) + 2, FIND("~", SUBSTITUTE("," + [Column Name]@row + ",", ",", "~", 3) - (FIND("~", SUBSTITUTE("," + [Column Name]@row + ",", ",", "~", 2) + 2))
While the above is a little overworked for your exact request, it does provide the ability to easily adjust this formula to pull the first, third, 25th, etc. based on the "comma" delimiter.
To adjust the above, you would adjust three pieces. The first and third piece indicate the entry number you want to pull out, and the second piece is basically the entry number plus one.
=MID(…………………….., "~", 2) + ……………………………………., "~", 3) - ……………………………………, "~", 2) + ……..))
To pull the first you would adjust these three numbers to be 1, 2, 1. To pull the third: 3, 4, 3. To pull the 25th: 25, 26, 25. So on and so forth.
Paul Newcome
Enable Auto provisioning with a default of 'Viewer' access
Enable auto provisioning to default to viewer access instead of provisional member, until/unless users get added to a sheet or workspace with higher access.
Until the new licensing model we had everyone in our company added to an 'ALL Active Directory' group. This group had viewer access to all reporting and dashboard content (unless we intentionally removed their access for confidentiality reasons). With the new licensing model, we had to DELETE that group because it forced every new user to be added as a 'Provisional Member'. The maintenance nightmare of this can't be overstated!
We went from everyone being able to see how great the Smartsheet platform (and our content) was, to very few seeing it. Clearly, this does nothing to increase user interest in Smartsheet. We had so many people who started advocating for Smartsheet simply because they were able to see the cool things it could do. Now it is locked away to prevent unbudgeted spending by unauthorized people adding new users.
Thank You
tzaczyk
Downloadable Automation List with Selective Upload
Sometimes, after setting up a sheet, I realize I need automation from another one. It would be helpful to download a list of automations from that sheet and upload only the ones I need, instead of importing everything
Christina09
Calendar Comment Notification
When adding a comment on the calendar the emailed notification does not provide any relevant infomration.
David Reyes
Re: Critical Path - Remove a set of tasks from the CP
Alternative work-around:
Add a line that has a long duration and make the final pre-launch item a predecessor to it. As long as your new fake line has an end date past any other, you will see the critical path you want.
Vince T
Adding Today Line in Gantt View to exported PDF/PNG file
Currently, there isn't a way to include the "Today Line" (current date line) in Smartsheet Gantt chart exports (PDF/PNG).
Frankly, this is baffling. Showing the current date on a Gantt chart isn't a luxury; it's a fundamental, basic feature that every project management software should offer. It's truly puzzling why this issue has persisted for years without a resolution. The absence of this simple visual marker significantly hampers our ability to share clear, actionable project status updates with stakeholders, forcing us into inconvenient workarounds.
This isn't just a minor inconvenience; it's a significant oversight for a tool designed for project management. I strongly urge the Smartsheet team to prioritize and implement this feature as
soon as possible. It's long overdue.
Please leave your comments and upvote this post if you agree. Let's make sure Smartsheet hears us and fixes this critical gap without further delay.
Yoshi_JPN
Re: Showing today's date in gantt view
How do we have the TODAY'S date dotted line "Print" in a pdf. In Gantt view it does not show in the print.
Is there a setting?
D_Arch
Having automated backups (such as weekly) the formulas also included
Having automated backups (such as weekly) the formulas also included.
It would be so good!
Mark_ K
Re: Manage seat types more effectively at scale!
Still a HUGE problem. Now that they will be downgraded they will be removed from their groups. This is going to cause a mess for myself as an admin and many different groups to realize what group they need to be put back in. I also will not know when and who was changed without having to go into admin center. This is a downgrade at best causing more issues then even just getting rid of the access where free users could at least comment.
AngB789
Re: Manage seat types more effectively at scale!
@Ryan Dougal The viewer Downgrade function seems like a MAJOR problem, depending on how this message is read:
Changing someone to viewer triggers the following:
Changing this Member to a Viewer will impact their work on many items. They'll have to
request permissions on each item
to regain current permissions.
This change will:
- Prevent them from collaborating on all existing items by removing their Editor and Commenter permissions.
- Remove them from groups that were shared to items with Commenter permissions or higher.
WHY would the downgrade remove their access to all items, instead of just changing access on the items they have to view only?
Or, is that what it does, and so it's not REMOVING permissions; it's just UPDATING permissions?
RobR_ABC