-
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.…
-
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…
-
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…
-
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…
-
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…
-
Search and replace contacts
Hello everyone! I'm having some issues getting my head around the search & replace function: I have a standard project task with placeholder values for assignees (Ie "Project Manager" or "Consultant). In order to avoid manually entering every contact, I want to search and replace "Project Manager" with "John Doe".…