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?
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.
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…
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.
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…
I opened ticket #06169967, and they recommended submitting the product idea. After deleting items and saving the sheet, we can no longer recover items from the Activity Log. Recover should be added additionally to the snapshot option.
你好,我想把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…
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…
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.
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…
