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
Formula for if check show another field
I have a sheet that I check off what someone purchases. However I would like to them have one spot on that sheet that shows everything someone purchased for reporting reasons. The below isn't in SS but its what I will have in SS. So the place that says Purchased, is a check box, then it has the item to the right of it.…
What COUNTIF formula can I use to count tasks assigned to each person
I need help in finding a formula that'll work. I need to count how many "Monthly Bookkeeping" and "Payroll" tasks are assigned to one each associates.
Returning a value from a table if the date in the date column is TODAY
Hi guys, so I'm trying to create a formula that will return a value if the column to its left is today's date. This will be for a metric widget I want to create which will update each month displaying the current months total cost. The table I want to create it from is below: So I just want to create one cell under "This…
"Today" date
Hello, I was wondering, how to include "Today" date in sheet? Which shows every day current date.
Networkdays and If formula help
Hello! I could really use some help. I've reviewed previous Q&As and can't get my formula to work. I want to calculate net workdays based on a specific status selection and have it stop counting days once the status has changed. Status is in dropdown selection box. I've automated the start date to populate when the…
IF function in column formula not working
Hi Community, I have an IF function that I have working on a row but if it try and copy the formula into row below or convert to a column formula it does not work and gives #unparable. Formula is below. Am I missing something obvious? =((IF([FAS Time]@row > 0, "FAS, ")) + (IF([FSE Time]@row > 0, "FSE, ")) + (IF([Cust Care…
Using SUMIF with dates
Hello, I am tying to sum cells within a column that are greater than a specific date. Unfortunately, the current formula I am using isn't adding any of the cells that meet the date criteria. It only returns 0. Where did I go wrong? This is the formula I am using: =SUMIF([Order Date]:[Order Date], AND(@cell >= 2021, 1, 1,…
Moved: Column order in charts
This discussion has been moved.
How to count number of Past Due Tasks
I use the formula below to track my past due tasks : but it is not giving me the correct number currently my sheet does not have any late task according to my filter below : Which formula should I use to make it possible ?
How to Track Someone's Past due Task
Hi, I have tried to write down a formula at the sheet summary that tracks the number of past due tasks assigned to a specific person on my sheet but it is giving a #UNPARSEABLE error below is how I have done it : =COUNTIFS([Is Past Due?]:[Is Past Due?], "Yes", Status:Status, "In Progress", [Assigned To]:[Assigned To],…
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…