Best Of
Re: Formula Assistance - Pulling values after delimiter in text string
Hi @ConnorForm ,
You use a combination of RIGHT(), LEN(), FIND(), and SUBSTITUTE(). Here is an example of a formula that works.
Formula in "Last characters" field
=RIGHT([Primary Column]@row, LEN([Primary Column]@row) - FIND("~", SUBSTITUTE([Primary Column]@row, "_", "~", 3)))
Results
Explanation
- SUBSTITUTE creates a unique character in place of the third "_". Adjust the number "3" in the substitute to be "14" for your application.
- FIND identifies the position of that unique character in the string.
- LEN provides the length of the entire string.
- LEN - FIND provides the number of characters for the RIGHT function.
- RIGHT provides the characters at the end of the string.
Regards,
Neil Egsgard
Re: Group Columns in Grid
It would be great to be able to group columns... for various reasons.
One major one for me would be for hiding & unhiding info.
Similar to the way you can click the filter button once to filter versus unfiltered, it would be nice to be able to "Hide Column Group" or "Unhide Column Group"... this is something that would come in handy for quick data entry on sheets that are used by multiple people but controlled & kept clean by one or two individuals.
Re: Hidden Columns List
Having a hide/unhide checklist is the intuitive/obvious way to handle this, as noted by the other commenters. Please implement this function. Unhide all is complete overkill, and very inefficient way to show the columns. I may have 50 hidden columns tracking different metrics, etc.. and to unhide one of them the only option is to unhide all 50 and then re-hide the 49 that I want to remain hidden??? This is a great example of why there are comments online about Smartsheet making simple functions much harder than they should be.
Re: Be aware of upcoming changes to your Smartsheet login options
Our organization works extensively with external collaborates. One of the biggest risks we face is when we grant access to an employee of another organization and we are not informed when they leave. Without email-based one-time passcode authentication (tied to their corporate email domain), an external employee at another org could use their corp email address and password to access information in a Sheet / Workspace. Connecting the one-time passcode (OTPC) to email allows us to rely on that entity removing access to their email address as a control. As terrible as OTPC is, it is the simplest method we can conceive of to minimize this risk and add some additional authentication method.
The functionality recently released for external collaborator SSO / MFA authentication is not practical to rollout without extensive documentation and dialogue with the IT Departments at external organizations. We've tired - it doesn't work. It's a never ending loop of failing authentication that continuously takes users back to the main auth page of SmartSheet - https://www.smartsheet.com/content-center/secure-external-collaboration-new-require-corporate-account-and-require-multi-factor
For what it's worth, we greatly appreciate this soon to come OTPC option. Amongst all the haters, than you for implementing this.
Re: March Question of the Month - Join the conversation and receive a badge
I love the new song by Bleachers called "Modern Girl". It so cool to see a band in todays age still making 80's inspired pop rock hits! This song makes me want to DANCE DANCE DANCE!!!!!
Create automation to move attached image to a cell
SmartSheet should include the function to add an attached image (.jpg) to a cell as an automation, or, allow images to be added directly to a cell via a form.
This would be a very useful tool that would replace other services we pay for now with other vendors etc…
Modified SUCCESSORS() function to report more than just direct successors
WHY IS THIS USEFUL?
This updated function would allow us to filter the spreadsheet for only the driving path to a particular row#. This would be similar to a filter for critical path, but enable much more flexibility.
Current status: I've successfully generated a "Successors" column, listing direct successors of each row, using the following formula:
=JOIN(SUCCESSORS([Task Name]@row), ",")
However, my "successors" column only shows direct successors. It would be very useful to be able to identify ALL successors, all the way down the dependency tree (e.g. successors of successors, successors of successors of successors).
Suggestion: =SUCCESSORS(value, N)
where 'N' is an integer representing the number of levels down the dependency tree to report. N=1 would generate direct successors, operating the same as the current function. N='all' would be equivalent to 'all' successors, all the way down the dependency tree.
Workflow:
If I'm interested in only showing all tasks contributing to the driving path to a particular task row#, all I need to do is create a "Successors" column using the new function: =SUCCESSORS(column@row, 'all'). Then I can filter my "Successors" column for anything that contains my row# of interest. This would
Re: fix the color of the outline on dark background cells highlighted by the find cmd
I would agree with this, but would not constrain the request to instances where the sheet has a dark background. Even in the default white view, the outlined cell as found via the CTRL+F command can be difficult to see. If the outline was a thicker boarder, that would be helpful along with maybe filling in the "handle" block on the far left of the row that the particular cell is located within.
Alternative to Dynamic View?
We are currently using smartsheet to manage our various projects. We would like to be able to have a project plan (sheet) that has certain columns visible to the customer. We do not like dynamic view - it doesn't look like a project plan and isn't really usable for a customer to regularly update/work in.
We are trying to explore having 1 sheet viewable for the customer, but a master project sheet that isn't. So this master sheet would house internal information (columns), comments, tasks - things we don't want the customer to see. The master sheet would then copy checked rows into the customer facing sheet (which is essentially a pared down version of the master sheet). We are having trouble figuring out the best way to copy as it's static. If we update the master sheet, it doesn't update the customer sheet. Is there a way to have both sheets update each other?