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 count contacts or email address in contact column
Hey folks - I created a column that is a contact list. In that column there are full email addresses or the Smartsheet contact: Question - how do I create a summary formula that counts either of these and gives me a full count for the number of times either Jeff Moser or jeff.moser@email.com are used?
count values
HI, I have a form with checklist info for different types(Type 1 , Type 2), also in the form i specified minimum nr of selection for each types. After submission i want to check whether submitted info has the valid nr of selection r not Ex)For Type 1 person has to select minimum 1 checkbox For Type 2 person has to select…
Using Forms as an Trigger Input to a Smartsheet
Situation: Users want to use the Form as input to update the smartsheet (and also minimize cell overwrites or delete errors that come with users entering data manually in a sheet...). Idea: Create a Form in the smartsheet , use an column (Checkbox = Checked) on the Form to generate a cell with new data. Create a workflow…
COUNTIF, Cross Sheet, Multiple Contacts
I am counting the number of times a contact is referenced in the Assigned column, cross sheet. There can be multiple contacts listed on each row but I am just looking for a total count of the number of times an individual is listed. This is the formula I have, but returns unparseable. =COUNTIF({Internal Comms Intake Range…
Pre-populate formula form submission
I have developed a form that reports data back into a smartsheet when submitted. I need to apply formulas to the data in the SmarSheet. How do I prepopulate the SmartSheet with the formula's so it outputs the calculation in the sheet? Currently each time data is submitted from the form it creates a fresh line without the…
Cannot delete files from reports
We regularly delete files from the attachment column, a very important function of our process. As of today, it stopped working and the "Delete" function is grayed out. See attached. We can only delete from the sheet which is only a temporary workaround and not everyone has access to the sheet. Is anyone else experiencing…
Remove everything to the right of a character
Hi, I've searched the forum, but can't seem to find a solution. I have a series of domain names all different length. Some of them have subdomains, some don't. I need to automatically remove the subdomain text. Examples: Domain 1: thisisadomain.com/ = no issue Domain 2: thisisanewdomain.com/en = I want to remove everything…
Formula INDEX/COLLECT CLIENT VALUE by MONTH
=INDEX(COLLECT({Sales Pipeline Range 1}, {Sales Pipeline Range 3}, @cell = [Account Name]@row, (SUMF{Sales Pipeline Range 6}, MONTH(@cell) = 1)) I want a formula that recognises on a referenced sheet a client name, and totals the value by month. On the reporting sheet I have a table with a column for [Account Name], which…
Conditional Drop-down list columns
Hey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is set to "Work stage 2" column B's drop-down list changes automatically to a different list. Say…
How can you sum a column with blanks cells
I am taking the sum of a Column from another sheet but it has blank cells please help me to overcome this problem...
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…