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.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Follow-up on Unsubscribe Option in Email Alerts
Below is the link to previous discussion by Mike: https://community.smartsheet.com/discussion/16866/unsubscribe-from-email-alerts I’m following up on Mike's query regarding the unsubscribe option in email alerts. Has there been any progress and we need to remove the option entirely, as many of these alerts are mandatory.…
Formula Help
I am trying to set up a metric sheet that pulls from helper columns on a sheet. The helper columns are set up to count values in a multivalued drop down list. I am want to use the date (specifically the month) and then for each column in my metric sheet I want to use the value above in the column to count items per month.…
Count Topics by Request Across Sheets – COUNTIF Formula Returning 0
This discussion was created from comments split from: COUNTIF with multiple select dropdown column.
Need to highlight if two numbers in two different columns match
I have a number of days column called "Adjusted Duration" (it is calculated from two other columns) and then I have a helper column called "Days" that is a number that is converted from the System Duration column into a number using this formula (=Duration@row). I need to compare these two numbers (Adjusted and Days) and…
Formula to count active projects if dates are not equal?
For project tracking we have an original end date and an actual end date. At the beginning of a project the dates would be equal, if there is slippage and the date is different we would update actual end date to the new end date. We have a dashboard with a widget that shows the count of projects where the end date changed.…
Best Practice for a Needed Formula
Good Morning! I need calculate a sum for our total numbers based on our Fiscal Year. I am trying to find the best formula to accomplish that. I am not sure if a SUMIFS is the best way to accomplish this. I need it to calculate based on the Current Date being greater than 10/3/24. I know what I have below is incorrect it…
how to convert a text date to a date
I have a column that brings in a date and time ex 08/22/2024 05:30:22 PM I want to extract the date portion into a date column, but I keep getting a #invalid Operations. DATEONLY will not work because this is not a system generated date, it is coming in from another system. ex =LEFT([Inquiry Date]@row, 10) does not work…
Formula calculation to find percentage calculation of one location from 5 different locations which
Formula calculation to find percentage calculation of one location from 5 different locations which are not older than last 30 days, which shows the result as "#Unparseable " =ROUND(COUNTIF(City:City, "A") / (COUNTIF(City:City, "A") + COUNTIF(City:City, "B") + COUNTIF(City:City, "C") + COUNTIF(City:City, "D") +…
Need formula to highlight row if same site # was entered within the week
Hi, My team currently works off a Smartsheet that tracks task e-mails we receive. Recently, we've been receiving a lot of duplicate items in our e-mail that we categorize with Task Subcategory "(TE) Critical Date Entry" on our tracker. Each e-mail corresponds to a specific site with a specific Location #. Basically, I'd…
Conditional Text
Hello! I am trying to figure out if I can do a sort of conditional text entry. For example, if I enter "St. Bernard" in a cell in column A, then the cell in same row of column B would auto-fill with the word "dog" but If I were to enter "Maine Coon" in a cell in column A, then the cell in Column B would auto-fill with the…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Question about copying a sheet
I use Smartsheet to track my yearly activities. I have a sheet that is connected to this sheet for calculations that feeds into a dashboard. Hopefully that makes sense. My question is, I want to copy this entire thing and start new for 2025, however when I copy, the calculation sheet is still pulling from the 2024 sheet.…
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags