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 can I bring back the word yes, if checkbox is checked in another sheet?
I have 2 sheets that I am working with. 1 is a status report that our Lead enters pertinent dates and information regarding each active project. The second is an intake sheet that is project specific, i.e., its pulling all of the data for one particular project that is entered on the status sheet and laying it out in an…
No options for selection of destination sheet to copy rows with automation
Trying to copy rows across sheets across workspaces (both of which I own) but when I go to select destination sheet nothing show up, blank screen. Any thoughts on what I may be missing here? Thanks in advance
Please help correct my formula - copy/paste results in carriage return and quotes around text
Here is my formula: =[Client Name (Avi)]@row + "-" + LEFT([Request Category]@row, 1) + "-" + MID(Created@row, 7, 2) + "-" + [Request ID]@row + "- " + JOIN([Services Requested - Utility]@row + [Services Requested - Waste]@row + JOIN(" -P")) When I copy/paste the cell (or export to Excel), the text looks like this (two rows,…
Pair staff to employees based on criteria and rotate through the assignments
Hello, I am trying to set up a sheet where we have a form attached to it that an employee submits to have a "coffee chat"/1:1 with someone from a different department. Within each department we would have multiple employees that can be chosen from to have that 1:1. I want my sheet to auto-assign someone from the department…
Using COUNTIF to return fields that contain certain test data
Hi Smartsheet Community, I am trying to create a Sheet Summary field. I want to count how many times my primary column has "D:" in the task name. When I use COUNTIF it returns fields that only contains D: in the field. (See my attached pic). Is there something that I am missing or should I use another formula?
COUNTIFS and SUMIFS functions?
I created a sheet that is a roll up of various information derived from a master sheet. I am using this to create a dashboard. However, I am stuck on a few formulas. I tried SUMIFS and COUNTIFS, but I cant get it right and either get invalid ref or unparseable. I would like to be able to count the number of stars appear…
Forumla showing 0s - would like it to be blank if 0
Hello, I am trying to make my formula to be blank if a 0 shows up and I do not want a 0 showing up on my dashboard. I tried adding the if function and must of been entering it wrong because it did not come back as an actual formula. The below is the current formula I am using. I am pulling data from a set of rows based on…
Help with formula for "If column matches another sheet, check the box"?
Hello there, I am trying to get this result: If Branch # on this sheet matches {Branch Number} on reference sheet AND the {Month Name} on the reference sheet is "January", check the box. Thank you!
Totaling Scores Conditionally
Hi all, I'm putting together a resume scoring Smartsheet and want to total five domain values. Applicants can apply for either our quantitative analyst or qualitative analyst position. Some apply for both. All applicants receive scores (0-2) (dropdown) for 4 categories (relevant coursework, interest. etc). Quantitative…
Project Week Number by project start/end date
I am needing to calculate actual project week number as majority of projects cross multiple years. The current WeekNumber formula goes by calendar year, therefore resets each January. Project start - 12/04/2023 / Project end - 03/10/2025 12/04/2023 = week 1 03/10/2025 = week 56
Help Article Resources
Trending in Formulas and Functions