-
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…
-
Automation: lock row if attachments are present
I'd like to be able to build an automation to lock a row if attachments are present. How can I make this happen?
-
Sheets have Data Validation functionality?
Do Smartsheet Sheets have Data Validation functionality like Excel? I'm looking to preserve the order-of-operations and to ensure my automation triggers after users fill out 2 drop down cells, a text/number cell, and a checkbox cell. (The automation moves a row to an archive sheet, once the four cells are no longer blank.)…
-
Conditional Formatting for Duplicates
Adding the ability to do conditional formatting by column, similar to how I would flag a column for duplicates in Microsoft Excel.
-
Automate dashboard?
Dear SmartSheet Community, I hope this message finds you well. I'm reaching out to inquire about SmartSheet's capabilities for automating the creation of weekly and monthly reports. Our objective is to streamline our workflow by eliminating the need for manual report generation. We are particularly interested in:…
-
Best Practice for Capturing Project Info on PM project plan
My team is using the Project Management Office template set. I love the template set but I saw this Project Information section on a different project template and I like the idea. I added it to the Project Plan template in our PMO, but I can't figure out how to use it or if there's a better way to capture this…
-
Using COUNTIFS with OR function spread across multiple ranges
Hello, I am trying to build a COUNTIF function that will count all cells which meet criteria 1 and either criteria 2 or 3, which are found in different ranges. Example: In Sheet1, I have the following columns: shape, color1, and color2. In Sheet 2, I would like to create a function which counts all observations in Sheet1…
-
Comparing values from different sheets in excel
Hi, I've been searching for an answer to my question almost the entire day but can't seem to get it right, so hopefully Smartsheet can be my savior here 🙏 So I have Sheet1 in Excel with two columns, both with texts in it. Each row has a different word in it: column A, row 1=text1, column B, row 1=bananas, column A, row 2=…
-
Is there a way to pull info from a form submission and enter it into another form?
I have a form I am currently running, that whenever answered, needs to be reviewed by another person. I am currently using the approval workflow, and putting it in the email with a link to a form that the reviewer needs to fill out. Is it possible to take the info given from the previous form and put it in the next one so…
-
Data Over Time Report/Dashboard
Hello, What steps should I take in creating a dashboard that includes a graph displaying data over time? I would love to be able to click on each data point and a pop up of that data point displays information during that time period. Here is an example of something I would like to create in Smartsheets
