Technology
Discussion List
-
Need Formula: Per Facility per Model #, how much +/- from par level.In Formulas and FunctionsI need to add a column formula within the Stock Inventory Sheet, in the Qty. Above/Below Par column, that calculates per Facility per Model #, take the quantity from Order Type Stock Order Row – Facility Specific Part(s), how much above or…Answered - Pending Review 28 views 5 comments 0 points Most recent by Mark Cronk Formulas and Functions
-
Another automate RYG balls for parent based on childIn Formulas and FunctionsHi, I have a project plan with multiple levels of children. Currently, the RYG automation is as follows: =IF([email protected] = "Done", "Gray", IF([Due Date]@row > TODAY(+7), "Green", IF(AND([Due Date]@row &…Answered - Pending Review 87 views 5 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Smartsheet not saving consistentlyIn Using SmartsheetI have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
-
Email as form field and for copy of responsesIn Using SmartsheetMy organization has just started using Smartsheet and I created my first form. I have a required "Email" field. I also enable the submitter the option to receive a email copy of their submission, which also requires an email. I a…Answered - Pending Review 756 views 5 comments 0 points Most recent by Genevieve P. Using Smartsheet
-
Counting number of tasks per Assigned To contactIn Formulas and FunctionsMy task list contains parent, sub-parent, then children tasks. The workstream leader is assigned to both the parent and sub-parent tasks, and possibly sub-tasks as well. I need to count the number of tasks per "Assigned To" …
-
Character Limit - Need More CharactersIn Using SmartsheetIs there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.
-
Suggested or maximum payload size for Update Rows?In API & DevelopersI've got a service that updates a sheet's rows with data from another source. It works fine on a sheet that has <5000 rows and around 19 columns, but I keep getting error 4002 whenever I'm trying the service with a sheet with >11000 …Answered - Pending Review 50 views 1 comment 1 point Most recent by Etienne Mermillod API & Developers
-
Smartsheet - Azure DevOps integrationIn Apps, Integrations, and Add OnsHey guys, I'm trying to create a connection between Azure DevOps and Smartsheet but I'm having a lot of issues with it. Has anyone ever made a two-way connection between the two? Especially being able to update an item in Azure when a ro…Answered - Pending Review 46 views 1 comment 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons
-
Updating rows with multi_contact cell?In API & DevelopersHello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact c…
-
Cursor Bug when Referencing other Sheets in a FormulaIn Formulas and FunctionsHi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I…
