Want to practice working with formulas directly in Smartsheet?
Check out the
Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.
Product questions?
Ask it here! The community's got your back.
Discussion List
How to add duration to manually entered current expected date without adding weekends?
I am adding a column to my plan titled "Current Expected Finish". This column will be used when a task is going to be behind. For the first task behind, an expected finish date will be added to this column. I then want to automatically calculate how that affects the remained of the task. To do this, I want to take the new…
Searching multiple sheets for ALL instances of a keyword, not just the first.
I have multiple sheets that outline course topics and keywords by chapter (topics go from top to bottom in a cell). I want to build a sheet where I can type in a keyword and have returned all of the cell addresses for each course where the keyword appears in each of the course outlines. I can INDEX/MATCH, but can only get…
One Way Syncing two sheets
Hi, First time poster, long time user!! I am trying to create a real time estimated cost list for a client based on data from a project. The master sheet will contain real costs and also contain margins and private company info, and be only shared inhouse. Where a second sheet can be shared with clients and they can see…
Remove numbers if answer is text
Hey Community, The below spits out the answer : TBC60. As the milestone date is 'TBC'. Is there any way I could get SS to add nothing if the answer is text rather than a date?
Need help with "IF" statement...
I need a field in the sheet summary to return a 2 when status2 is "complete" (otherwise 0), and I need an 8 returned when status2 and status4 are "complete". I tried using this syntax but no joy… =IF([Status]2=”Complete”, 2, 0) + IF(AND([Status]4=”Complete”), 8,2) I also tried using the integrated AI but it didn't work…
Manage session sign-ups for a conference, with a way to cap participants at 15 per session
I have a user group that wants to use Smartsheet to manage conference session sign-ups through forms. The challenge is how to cap participants, and provide a note to try another session once that session is full. Joe Busch jbusch@urban.org
Index/Collect text from above previous cell
Hi there, I am trying to copy text from the previous cell if the time in column Number is between the times in the previous row for StartTime and EndTime. I have tried many INDEX/COLLECT and MATCH formulas but have not been successful. I'm including a link to the file hoping that someone can help me figure it out. My last…
Error Message: "Rows cannot be added to the destination sheet..." for my Copy Row Automation?
Hello All, How can we fix this error? The only change that was made was to the destination sheet and it was to change the owner from one person to another. Would that have anything to do with it? Here is the error in my workflow: Thanks! Ryan Holguin
Countif function for unchecked box
Is there a way to run the countif function if a check box is unchecked? I see a command example for when it is checked, but I want to exclude any checked boxes as those would mess up my counts due to the negative value associate when it is checked.
Count names that appear multiple times
Hello. I have a sheet that has a list of names. Some of the names appear more than once. I would like to get a total of how many times a name appears more than once. I do not want to total by name, I want a general total of how many duplicates exist. I ran data analytics and it tells me there are 117 duplicate names. I…
Help Article Resources
Trending in Formulas and Functions
