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.

how to add 6 months in a date ?
Hi, I have a date column and I want to generate a new date by adding 6 months to the date. I have used this formula- =DATE(YEAR([Go Live Date in V2]@row), MONTH([Go Live Date in V2]@row) + 1, DAY([Go Live Date in V2]@row)) but its only working within the year but if the date comes under next year it gave me an error so can…
Forms and Templates
I have created a project template, which consists of several sheets (deliverables, schedule, action lists, etc.) used on a project. One of the sheets is the "Project Intake Sheet", which has a "Project Intake Form" that will have some pertinent information and will feed some of the data in the other sheets. When I open…
Formula for today's date minus 3 days
I used the formula creator to drop a true or false in a column so I can use it for conditional formatting the row. This is what the system helped me create, however, when I changed and saved Assignment Date the field still shows False. I expected it to change to True. Thank you! Mary Anne
Return the value from the column that is not blank
This discussion was created from comments split from: If multiple cells are not blank - check the box.
Verify if there is comments in a row
Good afternoon, Is there any way to automaticaly know if a row has any comment or document ? My goal is to have a cell that return true or false if the row contains a comment or a document in order to add condition on my sheet. So is it posible to call the cell that contain conversations and comments to check if it is…
Percentage Formula Help
Hi, I am trying to pull the percentage of multiple categories for several counties. For example, There is one column that is a dropdown column that lists all counties and we report if there specific errors associated with the county. I am trying to pull the percentage of each error for each county. Can someone please help?
Returning a value based on whether a cell value @row can be found in another column in another sheet
Hi Smartsheets Community, I am trying to create a formula that returns a "Yes" or "No" value after checking whether the cell value in that row matches a value in a column in a separate sheet. =IF(INDEX({Master Governance Sheet ID}, MATCH([ID Number]@row)), "Yes", "No") I am getting an error in the formula. Any suggestions?…
Copy Rows with Hierarchy
Hi, I have a sheet with hierarchy once one is marked delivered the row with the hierarchy under it moves to a purchased sheet. Once it is in the purchased sheet I would like it to copy rows that are blank with the hierarchy back to the main sheet. The automation is working if I force it to run but it is not working…
Document Mapping Issue
Hi I have booking data for three different courses in one smartsheet. I have created the document mapping to create three different course certificates however when I run the automation to create the certificates it is creating all three certificates and not just the one I want. Does anyone have a solution?
Check checkbox column for both the parent and child row if the child row contains "Editing"
I want to generate a summary report of all items that need editing. However the "editing" line item only says "Editing", so I want to also bring in the parent row that says the name of the document being edited. I have a column that I want to be checked for any child row that says "editing" and also the associated parent…

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