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
Project Plan Template Formula Issue
I have a question on a formula used in a project plan template currently being used. Many times, the % complete (expected) is greater than 100%. The formula currently being used is Expected Effort Complete/Cumulative Effort. The Cumulative Effort is the duration of the task, in days, and the expected effort complete…
Need Formula to Count unique ID's that are all approved
Pull information from report to sheet
Hello, I have a template that my team uses for data collection each time we get a new lot of diagnostic tests we need to quality check. In one folder, "data collection forms" there are many sheets, as each lot gets it's own sheet. New lots are tested every day, so the sheets in this folder are constantly being added to. We…
Checkbox for Envelope Status Column
I have a column called "Envelope Status" for tracking SS generated DocuSign docs. I also have a column that is a checkbox and for that column, I'd like to write a formula so when the status is certain values it is checked and stays checked. The possibilities for "Envelope Status" are: Blank (meaning nothing is in the…
Count non-blank cells in a row
Hello, My smartsheet tracks document reviews and approval. I'm trying to create a formula that returns the number of review rounds per document, by counting "resubmission due" cells if they are not blank. I tried this formula for the first two rounds as a test, but the result is only "1" despite two cells being populated:…
do a calculation based on drop dowm list
Hi, I have same data comming from differents drop down lists and I am trying to do some calulation based on them, each list represent a certain % in my calulation. I have hard time to do any type of caluclation with them, please help if you have an idea.
Creating scheduled date from last date given
Hello I am having problems creating a formulla .The formula needs to reflect the due date which is: Date of Last PCR Test + 14 days. I tried the following but its not working: =[Last PCR Testing]@row + 14 days() Any help would be grateful
Countif except N/A's
I have two columns that I'm trying to build a countif function for. First column has a value: A,B,C. Second column is checkboxes with N/A if the team member is not required to complete. End result I would like to get a final count of all the A's that are required to complete the training. =countifs(columnA:columnA, "A",…
Formula Help w/AND
Hello Community! I really struggle with formula syntax. Here is what I'm trying to do. I have a project plan and when certain milestones complete, I want to count the actual "widgets" I completed. My project plan has multiple phases so the completion of each phase adds more widgets to the bucket and I want to reflect that…
RE: Displaying percentage
Hello, I am having some issues obtaining % in some columns with the exception of the first application. I am using a similar formula but only getting it correct for the first application, i.e I am getting a true percentage. The other applications resulted in getting a fraction instead of %. Can anyone say what am I doing…
Help Article Resources
Trending in Formulas and Functions
Need to find all instances of value and return any non-blank cell from another sheet?
Hello Everyone, I'm stumped and need some assistance. What I am trying to do is look for the value in the Cable Number column (Cable Number]@row) on the master sheet in the Cable Number Column on the Update Tracker (Update Tracker Cable}). There will be multiple times this value is in this column but some dates will be…
Hello I am trying to create a formula that returns a specific date when a dropdown selection is made
class requested start date Jan 13, 2025 - July 14, 2025 Oconomowoc, WI Jan 13, 2025 - July 11, 2025 Huntsville, AL (new site) Feb 10, 2025 - Aug 11, 2025 Amsterdam, NY Mar 24, 2025 - Sept 22, 2025 Fontana, CA Apr 21, 2025 - Oct 20, 2025 Oconomowoc, WI May 13, 2025 - Nov 17, 2025 Huntsville, AL Jun 16, 2025 - Dec 15, 2025…
How Do I add Sum(Children) at the bottom of the children rows
Hi, How do I use the =Sum(Children) function in Smartsheet to sum child rows and display the total at the bottom. I usually create a parent row, then add rows beneath it, indent them and add the formula =Sum(Children) to the parent row to calculate the total. However, that structure was confusing for users, and they…