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
Using formula output in another formula- problems?
Hi All- I have an IF formula that I am using to compare before/after a date. All columns are dates (column type), but 2 of the columns are calculated dates- meaning, the dates are calculated from other sources (i.e. Date1+ 30) When I try to use that output in my formula, it will not correctly calculate the True/False…
How do I split these in multiple columns A1 = red;orange;yellow;indigo;blue;dog
I will have the first column as dump and formula on the succeeding columns to split them by semi colon.
Populating Data based on another cell
Is there a way to populate what is recorded in a cell given what is in a different cell? Not a formula with numbers, but data. Example Column 1 = John Smith, Then Column 2 would automatically populate ABC Column 1 = Jane Doe, Then Column 2 would automatically populate XZY. Not sure if there is an automation or a formula…
Alternative to a Hyperlink
Hi, I was hoping to possibly use a hyperlink type function for my use case so it is disappointing that SS doesn't have this capability. Does anyone have any suggestions on how to accomplish the following: I am building a set of ISO27001 risk assessment sheets and I have a main sheet where there are different threat names…
Can a row of data in one sheet be automatically copied to another sheet based on data in one cell.
Looking for help with the following scenario. Have two project sheets. One is for projects under development. The other sheet is awarded projects. There are some matching columns between the two sheets, but not all. Would like to have all data in matching project columns in one row be automatically copied over to the…
Filtering
Can I filter by a number using "contains" as the search criteria?
Adding fake user accounts - Contact list_assign to (within project plan)
Curious if anyone has suggestions. We want to be able to include a few place holder names within the project plan. The goal is to be able to do a find and replace the place holder names, with an actual person. We want to avoid adding these fake accounts to the user management section and not sure if another option outside…
Adding "fake users" to the project plan - Assigned to.. Contact List
Curious if anyone has suggestions. We want to be able to include a few place holder names within the project plan. The goal is to be able to do a find and replace the place holder names, with an actual person. We want to avoid adding these fake accounts to the user management section and not sure if another option outside…
MailTo Link
I'm trying to add a Mailto link to a dashboard using shortcuts. I've used is.gd? and bit.ly to try to make this work: <a…
Comparing a Date
This formula is returning INVALID OPERATION. I am going to be doing much more than this as a final formula, but if I can't get this to work, I can't go any further. I'm not too familiar with Date formulas yet. Originally I had 07/01/2021, but it was suggested to be year, month, day? =IF([Anticipated Project Start Date]@row…
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…