Best Of
Option to Toggle off Admins Receiving Access Request Notifications
With the new update rolled out last month, all sheet/workspace Admins now receive access request notifications instead of just the Owner. This is causing major headaches for the large corporation I work for.
We have thousands of users and many do need Admin permissions to perform their tasks in workspaces. However, they do NOT need to be reviewing and approving asset access requests. It's also incredibly annoying to everyone that unnecessarily receives these notifications.
We would like the option to change this setting to only allow Owners and Asset Admins receive these notifications.
The only fix I've seen offered so far is to lower peoples permission level. However, this does not work for our company. It would cause an unnecessary burden on our teams to demote everyone to Editors and then have to go in and give Admin permission to any specific assets within a workspace that people need.
Re: Automatically Sort Rows in Sheets
Adding another vote for auto-sort. Having to manually update the sort feature every time is so tedious. This is already a feature in Notion and Airtable which makes them both much more user friendly.
Re: Give Administrators full vision and access to all sheets
Just adding a comment here because this would be VERY helpful. I would also love the ability to assign individual favorites and views (beyond just Work Apps) aka for non-licensed users. I consider this a natural progression to sys admins being able to access all sheets. However, having access to all sheets would be a huge win for me since I'm also responsible for making sure our executive dashboards actually include all relevant data regardless of rogue Smartsheet users.
I'm a single admin/project manager for a company of about 700 employees and rolling out Smartsheet to all would be MUCH easier if I could create what I want them to see/interact with and ensure they all have easy access to it.
Re: Extract a number which is sandwiched between text
Hey @KaseyK
Here's one approach for determining the contents of multiple brackets. The first IF looks to see if any brackets are present. The second IF evaluates how many bracket pairs are found in your string. The substitute function is used to leverage it's ability to specify which occurrence of the search term is being addressed. The "~" is a placeholder for that named occurrence.
First set of brackets, if any
=IF(FIND("[", Description@row) > 0, MID(Description@row, FIND("[", Description@row) + 1, FIND("]", Description@row) - 1 - FIND("[", Description@row)))
(If desired, you could use the MID formula below (replacing 2's with 1's) in place of your MID formula: =IF(FIND("[", Description@row) > 0, MID(Description@row, FIND("~", SUBSTITUTE(Description@row, "[", "~", 1)) + 1, FIND("~", SUBSTITUTE(Description@row, "]", "~", 1)) - 1 - FIND("~", SUBSTITUTE(Description@row, "[", "~", 1))))
Second set of brackets, if any
=IF(FIND("[", Description@row) > 0, IF((LEN(JOIN(Description@row)) - LEN(SUBSTITUTE(JOIN(Description@row), "[", ""))) / LEN("[") > 1, MID(Description@row, FIND("~", SUBSTITUTE(Description@row, "[", "~", 2)) + 1, FIND("~", SUBSTITUTE(Description@row, "]", "~", 2)) - 1 - FIND("~", SUBSTITUTE(Description@row, "[", "~", 2)))))
Third set of brackets, if any
=IF(FIND("[", Description@row) > 0, IF((LEN(JOIN(Description@row)) - LEN(SUBSTITUTE(JOIN(Description@row), "[", ""))) / LEN("[") > 2, MID(Description@row, FIND("~", SUBSTITUTE(Description@row, "[", "~", 3)) + 1, FIND("~", SUBSTITUTE(Description@row, "]", "~", 3)) - 1 - FIND("~", SUBSTITUTE(Description@row, "[", "~", 3)))))
etc
Will this work for you?
Kelly
Re: Send Dashboard via email - manually and automated workflow
I'm in favor of sending a copy of the dashboard automatically at a certain frequency like you can for reports.
Re: Send Dashboard via email - manually and automated workflow
This feature would be a huge plus - those at the Admin level appreciate this type of view the most!
Re: Automation to allow Cell Change for Checkbox "Flag" or "Star"
After refreshing dozens of times and running through the list of cells over and over, I found my way to this post. I can't believe it!
I changed my column to the "checkbox" style, updated my automation, changed the "checkbox" style back to the flag, and then it disabled the entire workflow. But it is a checkbox column....?
It's been over a year now. Is there any sign of this getting updated?
I want rows to automatically be "flagged" based on certain conditions. A checkbox implies that something is "good to go" or "complete". The flag style will show that something needs to be reviewed -- "attention required". I don't want people to manually skim the sheet for the conditions that require attention.
Re: Option to Not Include Sheet Link on Notifications
Yay!!! Hurry, hurry, hurry please …. 😊 Thanks!
Using OR with the CONTAINS function (-or- How to Hack the CONTAINS Function)
This one comes up a lot, so I thought I would provide a few ways to solve it. The question is this: can I use the OR function in the CONTAINS function? For instances, you want to see if a cell contains "apple", "banana", or "orange".
In short, you can't use OR in the CONTAINS function (TLDR: because OR provides binary true/false outputs, so it doesn't make sense to put variables inside it).
But let me provide two solutions:
1.) Wrapping multiple CONTAINS functions within the OR functions. Yes, this is what many people are trying to avoid, but it does the job. This is formatted like this:
=IF(OR(CONTAINS("apple", column@row), CONTAINS("banana", column@row), CONTAINS("orange", column@row)), "Fruit!", "No Fruit!")
Now the OR function is searching for instances where any of the CONTAINS statements are true, meaning if any of the fruit names are inside the referenced cell.
2.) Hack! Reverse the polarity (this is my favorite) -- you can sometimes flip the "search for" and "search within" portions of the CONTAINS function like this:
=IF(CONTAINS(column@row, "apple banana orange"), "Fruit!", "No Fruit!")
Now your IF statement is looking for IF the entry in column@row is contained in the string "apple banana orange". Is the value in column@row "apple"? Great! "Fruit!"
This only works if column@row contains the actual fruit names. It wouldn't work if it contained a statement like "I like to eat apples", because that statement doesn't exist in the string "apple banana orange". But there are a ton of uses for this flipped version of the CONTAINS function, and when it works, it's a lot tidier. I use it often to exclude certain items from lists that are thousands of lines long. For instance, if I have a list of lot numbers I need to reference, but I know that 5 of 10,000 are bad, I can exclude them with a formula like this:
=IF(CONTAINS(lotnumber@row, "AX3432 AC3924 AF4030 AQ2020"), "NA", lotnumber@row)
This format makes it really easy for me to add to the exclusion list over time -- I just stick them in the list.
If you have fancy shifting variables you want to look for, you can replace the string with a JOIN COLLECT combination function. For instance:
=IF(CONTAINS(lotnumber@row, JOIN(COLLECT({bad lots}, {lot signifier}, "bad"), " ")), "NA", lotnumber@row)
The above example could be accomplished via other means, but this is just to show that the contains function is pretty flexible.
I hope this is helpful!
Re: April Question of the Month - Join the conversation and receive a badge
Knowing I wouldn't fail? I would retire today knowing I would have enough money to retire and live comfortably in a tropical paradise with a cold drink, blue skies, refreshing breeze and lapping waves!