-
Is there a way to set up automated reminders for just specific columns in a sheet?
I'm working on a sheet that has lots of columns, so want to create an automation to remind people to only update specific columns on a biweekly basis. Is this possible?
-
Warning message when Duplicate entry is done through form
Is there a way to get pop up message saying there is a duplicate entry of the line u entered through form. Something avoids duplicate entry.
-
Collect information from a changing database
I'm trying to find a way to search for information in a big database, but this database is constantly changing (new sheets imported with the API) The big database are split into 6 imported sheets (250 000 cells approximately on each sheet). This sheet is a list of products. I wanted to do a vlookup on these 6 sheets to…
-
Is there anyone on the millwork shop side that can collaborate with me on how they use Smartsheet'?
We are a millwork shop that uses Smartsheet for all of our projects. I want to see best practices on how to use Smartsheets to our advantage. As of right now we have a "sheet" that works as our production schedule but it just seems like a big sheet with lots of data. Thanks in advance.
-
April Question of the Month - Join the conversation and receive a badge
Hi everyone, We're ready to kick off April with a new question and opportunity for you to earn some badges and points while getting to know your peers! How would you like to see Generative AI applied to help you do more with Smartsheet? Get creative or share a practical use case -- all ideas and thoughts welcome! If it’s…
-
Combining Multiple IF AND Statements
Hello, I am trying to combine the 3 statements into one. They all work independently however, I am missing something when I try to combine them. These each check a checkbox if the statement is true. Help Please! =IF(AND([Trans date falls w/in Black-out Period]@row = 1, [Covered Person?]@row = "Yes"), 1, 0) =IF(AND([Covered…
-
Best way to assign many items to multiple people?
I have a Smartsheet with some 700 rows. Each row needs to be assigned to a set of individuals. I will be doing this monthly and it took ages to set up the first instance. I thought making groups would help but apparently not. How can I make these assignments most efficiently, please? And what is the point of Smartsheet…
-
It would be cool to have the ability to direct message other community users
I was just thinking of a comment I wanted to make to someone since it wasn't directly related to the post I was commenting in. I could not find a way to direct message someone, even though we have an inbox.
-
NEW Question of the Month - Join the conversation and receive a badge 🏅
Hi everyone, Looking for more ways to get to know your Smartsheet peers and rack up some badges and points in the process? Introducing Question of the Month. Each month we'll be sharing a new ice breaker question for you to ponder and respond to. If you found a 20 dollar bill on the side of the road (and you had to spend…
-
Smartsheet Forum
Hi. I Think a Smartsheet forum should be created so that discussions can happen directly on your organizations portal. And also have an external use feature to include outside vendors to access.