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
Seeking a formula that counts specific characters in a cell.
My project task sheet has parent rows for each department and child row for each project within the parent department. Each project row has a LEAD DEPT column with dropdown options that show the department acronym and business unit---DEPARTMENT (Unit). The LEAD DEPT options are; DCM (Marketing) DCM (Membership) DCM…
Weekly Comparison
Hello guys, I am trying to add a column that will provide me a %complete for previous week. I have this week's percentage and a PM is updating that weekly however I was wondering if there is a way to have another column that would be updated with previous week's percentage without the manual labor (think of 300+ rows). Is…
Count between Dates
Hello I am trying to pull a few figures and am coming up empty on two situations.1. I would like to know the count of entries that have a date between 9-2-2021 & 9-30-2021. The range is correct where the figure would pull from. Below is the formula. The second question I don't' know where to start. I want to know how many…
How to combine two formulas
I have an Aging column (start date-Today) and once my Health Status G/Y/R/C column= C, I need the aging to stop. What formula would I use for this?
Creating a lead time formula
I am trying to create a leadtime formula between duration, start date, end date and predecessors. Help please. This is a new system for me. 🥴
Can somebody help trying to read only data from this Month
Hi My plan is to bring data from the current month, from a different sheet using cross sheets formulas. My code below is not working any idea why? It says #UNPARSEABLE Any help is much appreciated =SUMIF({Actual Completion Date}@row)=MONTH(TODAY()),({Completed Jobs Value})
Multisheet dependencies
Hello! I am working on multiple projects for a single client, but need them to communicate with each other so no two tasks are assigned to the client at the same time. I understand there is a manual way to create dependencies between sheets/projects, but is there a simpler function I could apply? Something like "If X…
Auto Label Parent Rows
Hello! I'm looking for ways to automate labeling the parent rows for an onboarding sheet. I want to automate the label of the day so that I won't have to manually adjust it every time. Here's a sample a screenshot:
Distinct Formula
Hello!! Thank you in advance for any assistance you can provide me. I have 2 columns (Assignee, Total Tickets) - Assignee is comprised of a list of names (most are formatted as email but a few are stated names). I need to create a formula that will provide me a listing of unique names (thus removing the duplicates). For…
How can i use symbols of 4 different colors for the following scenarios?
could you help me please? There are 2 parts; part 1; contract notice period, part 2; contract expiry time for part1; If the day remaining until the notice of termination is over 60 days; Green If it is between 60 - 15 days; blue If between 15 and the termination notice period; Yellow If the notice period for termination…
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…