-
Trying to Flag Overlapped Participants in Meetings
So I am trying to find a way to flag if there are the same people in multiple meetings. I am working with a drop down type format for the list of participants, so I am not sure how or if there is a way to compare the individual entries of the drop down to other elements in the column to test for potential conflicts.
-
COUNTIFs across multiple columns from another sheet
Hi all, I'm currently struggling to execute a formula to count the number of times a contact appears across multiple columns from a sheet I'm referencing. I know I can just add two COUNTIFs statements for each column but this doesn't solve my problem of only wanting a contact to be contacted once for each row (eg if the…
-
Checking checkbox if the cell on the same row in a different column contains one of several values
Hi all, I'm currently having a little bit of difficulty writing a formula for a checkbox column. I intend to write the formula so that the box will be ticked if at least one of three values (people's names in this context) appear in a different column on the same row. I can get it to check by only specifying it contains…
-
How do I search for duplicate data within a sheet?
Hello everyone! I am very new to Smartsheet and new to my position as a New Product Development Coordinator. My company utilizes Smartsheet to track new ideas for products as well as the progress of the projects done on them. We have a master sheet that all the ideas are filled into from a form showing who submitted the…
-
SUMIFS with OR function (multiple criteria in same column)
Hello, I am trying to get a sum if the criterion in a certain column meets one of several conditions. If the country code equals one of the country codes in the "country" column, I would like to sum the Total MVE for each country code. Right now I have" =SUMIFS([Total MVE]1:[Total MVE]66, Country1:Country66, ="AU",…
-
countif and contains statement for extended drop down menu
Hi all, I would like to reach out to the community to help me solve my (probably simple) issue I am facing. To provide you with some context: I am building an online database to enable tracking all the requested amendments and to gain inside into invoicing on a small scale. This database is created for different layers to…
-
New Template Sets for these Workflow Categories! Let me know your thoughts!
Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your organization work remotely more efficiently. Let me know your thoughts, but we are…
-
Hierarchy and Child IDs
Good morning. I have to create 2 forms which will populate parent rows and child rows. I need the parent rows to have a unique quote ID (have this set up now), and child rows to either not have an ID, or have a specific ID that will tie back to the specific quote number. How do I do this?
-
Input the date for a multi-select dropdown
Hi all-- I am trying to create an efficient way to track my samples as they move around to different facilities. Please see my screenshot for what I am working on. Ideally, I'd like to just have the check box as in the screenshot because it's easier and faster. Space on my SmartSheet is also a premium. Now, I'm aware that…
-
Certification Exam
Hi all, I want to take the certification exam for the first time and I wonder if I can retake it anytime without any limitations (I have a smartsheet user of course ), Because there is not a lot of tests out there to practice I think the best way for me is to just try it and i Want to know If I can retake it without any…
