-
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.
-
Why did most of my reactions dissapear, & why didn't my most recent ones get added to my count?
I had almost 10 upvotes (see the 5 upvote badge on the right) but now it says I have 2. Also, my most recent idea that I proposed has 73 upvotes & again, my count says 2. Why were my votes deleted, & why aren't the most recent ones counting? As you can probably tell, I'm a fan of the gamification on here. I love how it…
-
Keep getting this error when I try to request the "User Group Attendee" badge.
I keep getting the above error when I try to request the User Group Attendee badge. Not sure why. I've been to a couple User Groups now & I registered for them, so if it's a matter of an attendance list I should be on them. I'm able to request other badges, it's just the User Group Attendee one that's throwing me this…
