-
Nested if & countifs to generate a prefix based on number of occurrences
I am trying to get this part of a concatenate to work but keep getting #unparseable. The latter part of the concatenate works and generates a unique identifier for the project. However, the beginning section is meant to generate a prefix based on whether this project is the first, second (b), third (c) etc. project with…
-
Sheets, Reports, Dashboards and Workspaces now tied to Smartsheet Plans instead of Individual users!
Hi Community, Today, we’re excited to announce that sheets, reports, dashboards, and workspaces are no longer tied to individual users but instead they are tied to Plans. This means that as users change roles within organizations, leave organizations, or have their licenses removed, business workflows and processes built…
-
Add Email Distribution Lists Functionality to Contact Columns & Workflows
Our team and company use email distribution lists frequently, so it would be incredibly useful to be able to assign an email distribution list to a contact column and workflows so all members on that list would be notified accordingly.
-
Dynamic View: Un-editable Fields
I am having an issue with Dynamic View treating (random) editable fields as "Read Only." In this instance, Dynamic View is treating a Date Field as if it were a "Read Only." In the first screen shot, you will see that the "Date Resolved" field is not marked as "Read Only" in the design mode, however, when you open the View…
-
Error: There was an error submitting the form.
I am getting an error when I submit the form. The error says " There was an error submitting the form. Please try again. If the problem continues, contact the owner of this form". I have checked the automation and all the fields with logic. They all looks fine to me and earlier everything was working. Today, when tested…
-
Update data in one sheet from another sheet that updates daily?
Hi there, I have separate product sheets (70 of them!) for each product a division creates. Each row in the sheets has a unique line item number. The first 23 columns contain data pulled from one of our systems, including the line item number. The remaining 26-40 columns contain data that's managed manually. I have another…
-
Charting Text Dropdown List
Hello, I want to visualize the 4 options in a chart showing the percentage of each one. Also, I would like to show the same percentage for the 4 options within the sheet. I would like to know if one formula is an option or if I must create a column per option. Thanks in advance.
-
Control Center Global Updates
We are now using Control Center to provision projects and as we are learning how to use it better we need to keep doing some updates to the templates and the existing projects we have already provisioned. I have been using the Global Update feature, but when I use it to update a Dropdown list in a Dropdown column, the…
-
Need help calculating estimated completion date for production while excluding weekends
Hello Smartsheet Community! I have a project I am working on for work, and I am struggling with a formula to calculate the expected date of completion for our production orders based on a few criteria. A few things are missing that are confidential, but I have attached a picture of a practice spreadsheet: Please note: a…
-
Merged: Allow Customisation of the Limit for Latest Comment
This discussion has been merged.
