Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Outbound Cell Limit?In Using SmartsheetI'm curious to know if there is a limit to the number of times cells can be referenced from a sheet (source). Say, if you have a source sheet 2500 rows, and you need to reference a pair of columns from that sheet on 30 other sheets (so 250…
-
groups in orderIn Using Smartsheethi, is there a way yo have the group function in reports set in a specific order?? i tried adding numbers IN front of the status dropdown but it doesn't prioritize. (see Pic how 3 , 5 , 8 is at bottom) thanks.
-
Can you reload a form with fields prepopulated from the previous form submission?In Using SmartsheetWe have a form that allows users to submit ideas for an upcoming conference. We want to allow them to submit as many different ideas as they'd like, each one on a separate row, so we have the form reloaded after each submission. We'd lik…
-
How to expand options : [Array] to show picklist values ?In API & DevelopersI am using Node.js API calls to get the columns displayed in my terminal. Few of my columns are of types : Contact_List and Pick_List. I want the CLI to show me the options which are present in the dropdown in these columns. I want to expa…
-
Error code 5570 when sending e-mail notificationIn API & DevelopersI have a trial account with Smartsheet. I am using smartsheet API with curl to create/update few sheets. The requirement is to email these sheets at EOD to a couple of users. However, receiving error code 5570, 'you have exceeded maximum n…
-
You have exceeded the maximum number of emails that your account can sendIn Using SmartsheetHello, I vae encounterd with tes message below. I wrote the help desk but I havent received any mesage so far ( 3 days passed). I checked everwhere but I cannot see what shoukld I do.. Can you help me? Thanks, Aaydin
-
URL Query String to Populate a Form - Issues with " \ % charactersIn Formulas and FunctionsI'm playing around with the URL Query String to populate a form with data from one sheet to add it to another sheet (essentially, to copy rows, but only the columns I want). The problem I'm having is that at least 1 of the fields is a des…
-
Complex IF statement using columns containing formulasIn Formulas and FunctionsHi Everyone, Hoping there is a solution for this or a different way I can accomplish it. I have an IF statement in a column where the False portion is a formula referencing two columns that are formulas. I get #Invalid Operation. I know …
-
Why is an automated alert no longer working?In Formulas and FunctionsOur company has been using Smartsheet for over a year to organize the production process in our shop. Clients submit orders through a form, and when the order is added to the Sheet, we have an automated alert that is triggered to send a c…Answered - Pending Review 25 views 4 comments 0 points Most recent by matt Pazzaglia Formulas and Functions
