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.

Setting up a Workflow
I have a column in my Smartsheet for responsible person. I would like to set up a workflow that will send out an email to the person that is placed into the responsible person column, but would like to set it up where only one email is sent out for all items shown for that specific person. Is this possible? Do I need to…
Adding 1 day to date in an If formula
Hello. I am trying to add one day to a date if the row meets a certain condition. Instead of adding the day, it is putting a "1" at the end of the date string. I have confirmed both the original date and the column with the formula are formatted for date. What else am I missing?
Sheet Summary COUNTIFS using netdays
I am trying to count how many requests are open for more then 2 days in sheet summary. The above formula results in #UNPARSEABLE
How to write an if child, then parent formula?
I am trying to have the parent row flagged if the child row is flagged( at risk). I do not have much experience with formulas and I am really at a loss of what to do. Is there any one that can help write this formula and then explain how to apply it?
Filter Long-range "Phases" out of Calendars?
Hi all, I will try and make this question as easy to understand as possible, but it's gotten a bit complicated..... We have multiple individual sheets that go to a single group calendar. The individual sheets are set up for Gaant view and include long-range "Phases" anywhere from a few weeks to a few months, this works…
Formula for returning specific value depending on cell criteria
Hello- I'm trying to create a formula to populate a field with a fee amount based on the designated country group in another column. Essentially, I'm trying to say: If country A, return $125.00 If country B, return $160.00 If country C, return $125.00 If country D, return $160.00 If Staff/Comp, return $0.00 What I came up…
How to return a value from the range of cells with the most recent date.
I have a sheet like the one above for each of my 100 employees. I want to be able to run a report on all these 100 sheets such that I can see the most recent date of an employee review and what the expectations for the next period will be. I am trying to use row 6 (highlighted in yellow) as the row to pull the most recent…
Index Formula?
I am trying to make an employee sign in sheet that can automatically be updated each day. The supervisor's name is a drop box and they can single select the foreman. I want the "Name" column to update automatically the names that are associated with each foreman from the second screenshot. The sign in sheet would look like…
Can I count after a certain time?
Hello, I am using this formula =COUNTIF({Shipment Dump Range 1}, "yes") to count the number of yesses on my dump sheet. My question is, how can I modify this formula to count the number of yesses after 5pm for example?
Count Values In One Column Based on Values Of Another Column
Hi, I have 2 columns: Client (containing names of my clients) Status (containing the status of the client) I need a formula that counts the clients in Column 1 that don't have a status of Lost in Column 2. I have tried with CountIfs and Not(Contains) but with no luck Thanks!

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

Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags