-
User Level Admin
Proposal: Creation of a Dedicated User Administration Role in Smartsheet Objective: Introduce a new Administration Role within Smartsheet designed to assist with user management tasks while maintaining strict security boundaries. Scope of Responsibilities: Manage provisional users and oversee user licensing. Perform…
-
Adding multiple columns at once
Hello, Based on a previous post I saw in regards to rows, I wouldn't be surprised if multiple columns cannot be added unless done one at a time, however if it is possible can someone please assist? I would like to add about 5 columns at the same time without having to add them individual and name each one at a time. Thank…
-
User Subscription Model - NEED a static VIEWER ONLY option (interns, temps etc.)
User Subscription Model - NEED a static VIEWER ONLY option (interns, temps etc.) In the new User Subscription Model, what options exist if we need a user to ALWAYS ONLY be a VIEWER ONLY? Meaning no action can make them become an Editor/Provisional Member. This new User Subscription Model leaves the department that pays the…
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
Searching within a large dropdown list
Hello, I currently have an expense report for our company credit cards. On the expense report I have a drop down that lists all of the account numbers so that each line item can be posted to the correct account. There are hundreds of accounts and I would like to know if there is a way to broaden the search within the drop…
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Power Automate - Post Attachments to Row/Sheet
Hello everyone! I spent WAY to long looking for this answer so I thought I would share it with the Community in hopes of helping someone else. Problem: Adding attachments to rows/sheet is not possible through the standard SmartSheet Connector Solution: This can only be done by creating a Custom Connector. It CANNOT be done…
-
Sending email to create a row in Smartsheet
I am looking for a way in Smartsheet, wherein employees will create an email and send to a specific email address and once sent it will automatically create a row in Smartsheet(not using add in). Is there a set up in the email address that I can do to connect it to Smartsheet sheet just like a ticketing system? Is this…
-
Hi Everyone, I am Audrey :)
I work as Operations Coordinator at an International Education company in Australia. I have used Smartsheet for a number of years now and slowly became the go-to person for anything Smartsheet at my work. I have attended the Smartsheet summit in June, got the Core Product Badge and am constantly seeking to upgrading my…
-
Connect Xero Reconciled Bank Account Balance
Hi, I am completely new to Smartsheets and I have an issue with regards to integrations with other software. I basically want to connect the reconciled bank balance from Xero to a 12 month cash flow I am developing in Smartsheets. I am currently unsure which trigger via Zapier to pick and was wondering if anyone knew or…