-
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?
