-
Sharing Permissions and User Types Explained
Hi Smartsheet Community, We just recently released an Infographic in the Help Center to take on the sometimes confusing territory of account types and sharing permission levels. Here's the link: Infographic: User Types and Sharing Permissions Explained This is the first time we've done one of these in the Help Center, so…
-
Best practices and Governance
Hello We are using smartsheet more and more in the organization. Happily :) But as the number of users grows, so does the number of sheets, etc. A sound governance document is needed. I'm now digging into the subject and I'm wandering whether someone went through this exercise before me and would be ready to share its…
-
Regular Expressions (RegEx) with FIND function
Hi Team, I'm guessing that SmartSheet doesn't support regex in formulas as I get an #UNPARSEABLE error when I try it but I thought I'd better post the question here before I make that assumption. I have the following text in my "Subject" column: [1751] - Guide Posts With the formula: =MID(Subject1, FIND("[", Subject1) + 1,…
-
Will Smartsheet load my template items into JIRA?
I have a template I will use to kickoff projects that will have JIRA tickets in them. Can I copy and paste these rows into smartsheet once I have updated them so smartsheet can start the ticket in JIRA, via our connector? I am guessing I have to make the JIRA connection in a new sheet and then copy and paste my template…
-
Filtering out data from an equation
Hello, Is there a way to filter out specific data items from an equation? Specifically I am creating a sumifs formula and I would like to be able to filter out fiscal year data without making it a condition of the formula, that way we wont have to change the formula every year. I have a column that shows the fiscal year as…
-
Conditional Drop-down list
Good afternoon, Currently, my company is using smartsheet to build up a database of our quality issues. Since the department is new to this, data entered is not very robust: Many auditors simply log in, type in their name, work station and enter text describing issues as they encounter them. I want to take this to the next…
-
Formula to Ignore a N/A if selected from a dropdown, and not break the rest of the formula
I need to add another scenario to one of y formulas, If one of the departments does not have to approve a certain type of change, they will choose N/A from the drop-down. So I will need the Approval Status column to IGNORE the N/A in that row. So if only 3 people needed to approve it choosing then the non approvers choose…
-
Formula to create a Symbol response based upon a text string in the Comment
I am attaching from my emails a specific email response to the comments. The email will always have the same email the address is from. I would like to create a column using a symbol and say..... If the following text string is listed in any comment related to that record and to show a green dot.
-
Sheet notifications
I have been getting a daily notification by email of sheet changes for a while and that has been working great. After one of the smartsheet updates it also started appearing under notifications in the top right corner. That notification is redundant to the emails. Is there any way to turn it off?
-
Mirror Smartsheets
Hi all, I am trying to find a way to mirror a certain area from one smartsheet to another. The problem I am facing is that some cells are locked and I couldn't find a way to automatically create rows and columns in the sheet it it pointing out to. Does anybody here have an idea if there is a solution to that? Many thanks :)
