- Count Rows Where A Value in Multiple Columns is blank
Is it possible to count how many lines meet certain criteria AND have a blank value in Column 1 OR Column 2 OR Column 3? For example I have a Smartsheet with a questionnaire and am currently trying to calculate metrics from the answers in said questionnaire. One of my metrics is "Level 1 Completion" (which is equal to "Q1…
- 同时选中下拉列单值in another column
Hi Everyone! I need some assistance with a formula to extract single value from a multi-select drop-down to individual columns. I got most of the process to work but for whatever reason the formula for control 4 column ends up displaying a incorrect number "12." instead of "12.1" and control 5 column displays the whole…
- Assignees Receiving Duplicate Email and Request Alerts...why?
So recently some of our users have began receiving duplicate email and request alerts. If this is an automation programming issue, I'm not understanding what is causing it (I have been using the same format for all of our vendors and workflows without this problem). Is anyone else experiencing this/have any advice on how…
- Dependencies End Date Sets to Previous Day?
Hi! We have noticed that when Dependencies are on, filling an empty End Date cell (when the Start Date and Duration are also empty) with a date results in a cell value the day previous to the intended set date. Is this intentional, or is this a bug?
- Linking two sheets into one master sheet
Ok Here is what I got, I have two employees who work for purchase import section. From Rising the IPO to having the LC created to have the goods delivered to the factory. I have created a common grid header for each of them and they are populating it as I write this. I will then create a master sheet where I will put in…
- How can I make a multi-IF cross-sheet INDEX formula?
Hi there! I've been stumped on trying to make the correct formula for my situation. Any help is greatly appreciated! In one sheet (Data Collection sheet) I have a column for Sample ID and a column for Results. In another sheet that I'm using to report out, I have a column for the results of each possible sample ID. I want…
- Transfer ownership of Smartsheet items
We created a workspace and made our client (from different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client (without having to do it one by one for…
- Transfer ownership of Smartsheet items
We created a workspace and made our client (from a different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client without having to do it one by one for…
- DocuSign Integration: Logging in with alternative account
We're starting to use the DocuSign integrations since we've already been using it, and like the automation offered through Smartsheet. When I set up the DocuSign and created the two mappings we have for this project, I logged into my user account with DocuSign. However, I now realize that the envelopes are sending as…
- Core Product Certification Resources
Are there classes, tutorials or resources available for the core product certification that come as a course? Or do you just "study" on your own and then sign up and take the exam when you are ready? I am new to Smartsheet but would like to be certified. Thanks!
