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.

Why is the 3rd row always returning an INVALID VALUE with this formula?
My overall goal is to capture the delta between the line items on a day to day basis. If tomorrow it's 15,000 (in the green highlighed column), I want the colum to the right to show 868 (15k - 14,132). Then keep going every time a new row is added (automated from another spreadsheet).
How do I create a formula to count a key phrase in a sheet?
I'm looking to have a count of how many times a person's name is referenced in a sheet I created. I am trying to create a formula that will recognize the name even when there are other names included in the cell. I am referencing ANOTHER sheet in my formula which is where the trouble has started for me… Ex. =COUNTIF([{Ops…
I am trying to count the amount "yes" selection within a day.
I am trying to count the number of Yes answers in the incident column per day. What's a formula I could use for this?
Discrepancy with result in grid versus report
Hi Smartsheet, I'm using a formula to calculate the days open for individual case. The grid is showing the correct number of days however the report does not showing the same result. The report is only link to one grid file, which is the one showing below. Please advise. Thank you. Both of the screenshots below were…
formulas got messed up, and I don't know how to fix it
I'm using the Simple Project Portfolio template. I messed up one of the formulas on the Portfolio Metrics sheet, and now my dashboard and intake is messed up. How do I fix this?
Help with formula
Can someone look at this formula, its working for VSS but not for CPIC. It just stopped working couple of months ago =IF([Type of PRC:]@row = "VSS", DATE(YEAR([PRC issue date]@row) + 3, MONTH([PRC issue date]@row), DAY([PRC issue date]@row)), IF([Type of PRC:]@row = "CPIC", DATE(YEAR([Start Date]@row), MONTH([Start…
Help with Countifs
I am trying to figure out the formula for my metric sheet. I am wanting data to populate based on a date column and a column that allows for multiple selections (comes from form). Here is the sheet that my form dumps into. So, I am refencing the date column and the column on the right Where they can select 0-30ish things…
How do you make IF and IF(AND statements work together
I am trying to populate a cell based on multiple date criteria. I am currently trying to use the below formula but I am getting an unparseable error =IF([Date Submitted]@row > DATE(2024, 9, 30), 25, ""), IF(AND([Date Submitted]@row > DATE(2023, 9, 30), [Date Submitted]@row < DATE(2024, 10, 1)), 24, "")
Control Center Error Message
Hi all, I was hoping someone could assist. We were previously able to provision project successfully through control center, however now the automation logs are reporting a failure. I am receiving the following error message on all of the projects I'm attempting to provision: Unable to retrieve Custom fields from Resource…
Need help hiding checkboxes
I have a handful of project intake sheets, that ControlCenter looks at to automatically generate project files if approved. We have 2 types of projects that are intermingled on the sheets, and use 2 automations in CC. I'm now running into an issue with some users checking both approval boxes, and CC generates 2 sets of…

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

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…
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),…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags