Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Why did a simple search on text return partial matches?
In order to test the very basic search functions in SmartSheet, I added a unique text string to the Comments section in a few records in a few different ways -- with text before it, with text after it (a period), and alone. The search results don't make sense to me. It returned all of those three instances I created, but…
Formula tool bar missing
I am rookie, but I cant find the formula toolbar only the conditional formatting. Please help
Milestone Dates
Hi - I'm trying to figure out a formula that will pull in the next milestone date into a report or sheet. I want to include the project name, the milestone name, and the milestone date. I don't want to see all of the milestones, just the next one that is scheduled.
Meeting agendas
Hi All, I am wondering if some of you have ideas regarding setting up agendas for meetings. We have various sheets for example: Sales, Finance, Tasks, Schedules, etc. I want to design agendas for each weekly meeting. How can I get only specific items pulled through from all the sheets for what is relevant for a certain…
Totaling a column with check boxes
I couldn't find an answer that solved my problem so am asking this question. I am trying to sum up a column where some of the fields are checked and some are not. Can you please help me? I have tried looking at the SUMIF calculations and keep getting the #BOOLEAN EXPECTED error. Thanks in advance. Linda
Rookie Stage - Status RYGB
I dont even know where to start: Column Stage Column Status Dropdown List RED Ball Not Started Green Ball In Progress Yellow Ball Waiting Blue Ball Completed How and Where do I put in a formula to select from Status dropdown list Not Started and have the Red Ball show up automatically in Column Stage? I know this must be…
Advanced Notifications
Still loving this new feature but I am finding a couple of anomolies and I am unsure if it is something I am doing wrong. The email notification tells me that changes are highlighted in yellow, yet some are and some are not. Can anyone offer any advice? Many thanks Natalie Gorman
Viewing deleting rows
I've created a sheet that has 165 collaborators. They need to be able to change cell information. Occasionally the notification will say that a certain number of rows have been deleted. I need to be able to view what has been deleted to restore. The size of the sheet is currently 3,000 rows and changes are happening…
Status notifications to clients
Hello all, I am a new smartsheet user :) Can you please let me know if their is a way to send a customer the status of an order through smartsheet, i am trying to making it automatic from the order date when it is placed until the order is completed up to keep the customer informed and updated? and i need this to be sent…
Import from MS Project
When you import from MS Project do dependencies import?