-
Show + Tell
Hi Smartsheet Peeps! I'm not new here, but this is my first time introducing myself (plus, I want to get a shiny new badge ;P). I am a project coordinator/manager in the education world. I have been using Smartsheet for a little over 2 years and I am excited to be a part of this community. I learn something new everyday!…
-
How do I take information from two sheets and auto populate into a third sheet?
I am trying to set up this smart sheet where it has a entity that someone can select from a drop down menu. Once they clicked any entity I had it V lookup from another sheet and it would auto generate the address for that entity from a different sheet into the cell next to it. I figured out how to do this part. I am…
-
What wrong with this IF OR Loop statement
=IF(OR([Site]@row= "Kelowna", [Site]@row="Vancouver", [Site]@row="Victoria"), "British Columbia", IF(OR([Site]@row= "Halifax", [Site]@row="Moncton", [Site]@row="St Johns", [Site]@row="Grand Montreal"), "Eastern", IF(OR[Site]@row= "Central", [Site]@row="Tannis", [Site]@row="SW Ontario", [Site]@row="Toronto") , "Ontario",…
-
[RECAP] 5 moments we loved from the Start 2023 with Community party
We're still buzzing from all the energy you brought to the Start 2023 with Community party earlier this week! Excuse me as I do The Sprinkler dance while sharing our top 5 moments from the event. 1. Seeing Community's global presence. We kicked things off with a round of introductions in the chat from all attendees, and it…
-
Hello from Jo based in Australia
Hi everyone - Looking forward to becoming an active member of this community. My career is in MedTech and new business startups, specifically in Sales Leadership/Management and Business Development. Introduced to Smartsheet 18 months and am keen to transition into PM. Looking forward to learning more and would appreciate…
-
Search within a Category in SS Community
When using the search feature in Smartsheet Community after drilling down to a category (with 68 pages), the search feature should only search within that category, and not the ENTIRE community.
-
Clear check-box, without clearing associated Due Date columns
Hi I'm setting up a sheet for reoccurring tasks that have different intervals. I have a task column, interval column, last check, next check and a check- box. When the checkbox is ticked the Last check updates to todays date and this updates the Next check date, calculated from the number of days in the interval column. Is…
-
Unique documentnumbers
Hi, I would like to know if is possible to create unique documentnumbers based on input in coloumns. Or more important the opposite, prevent that a number is used twice. E.g.: Metadata Projectnumber will always be the same, drawingtype 1 will/might be different, drawingtype 2 will/might be different, area code will/might…
-
[Virtual Event] Start 2023 with Community 🥳
Make 2023 the Year of Community! Join us for a free virtual event for all registered Smartshet Community Members, where you can: Get to know other Members from around the world Meet some of our newly inducted Community Champions Give the Smartsheet team feedback on new projects we have planned, and more Plus, we'll be…