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.

Return Work Dates between start date and end date
Hi, I have 2 columns, [Start Date] and [End Date] on my sheet. I want to fill another column [All Dates] with all dates between and included start and end date. So if: Start Date - 8/24/2020, End Date - 8/28/2020, i would like the return values in a column [All Dates] to be: 8/24/2020, 8/25/2020, 8/26/2020, 8/27/2020,…
Reduction of Column Count from dynamic form
Has anyone found a way to reduce the column count from a long dynamic form? I was thinking of using conditional logic on a separate form with a copy workflow to move data, but I'm not confident it would be reliable. I'm running some tests now, but if anyone already has a solution I would be very happy to hear about it.
How can I get the contact information to update when there are changes to the reference sheet?
I have an Assessment sheet where contacts are auto assigned using a match Match/Index formula. I have updated the reference sheet with a different contact, but that change is not reflecting in the Assessment sheet. Is there an additional step I need to take to get this to refresh?
Formula to Forecast Material Quantity Received vs Consumed
I am hoping there is a formula to see what I will need to forecast to purchase for material received vs consumed. Any help would be greatly appreciated!
Auto-Alphabetizing Drop Down Options
I'd like for the drop-down and filter options to auto-alphabetize after a user enters or edits the options. Currently, the options stay in the same order they were entered in, so I either need to alphabetize them in my head or outside of the platform for a more readable experience.
Multiple IF, AND, NOT, & ISBLANK functions
I'm trying to create different status text to appear based on multiple criteria. I'm looking for specific cells to contain text to signify that a review process has reached that level. I've created a descending order If/And function that includes multiple "NOT(ISBLANK" functions to determine which cell is blank, thus…
Is there a function to have google sheets and smartsheet to have a live active link?
My company currently has two separate department that uses two different systems. My department is using Smartsheet and the other department is using Google Sheets. Is there a way for the two systems to communicate with each other with links and formulas?
Check box behavior
I need a formula to: if document number column is a duplicate entry then the checkbox needs to be checked and if the document number is blank or a non-duplicate value then unchecked- can Smartsheet do this?
Calculate percentage of value based on the day of the week
I'm working on a project for one of my customers. I need to be able to use the historical percentage of containers arriving at port on each day of the week to project the number of containers that are going to arrive at port in the future based of the forecasted volume in that given week. Struggling with the formula to…
Error counting Children Completed tasks referring another sheet
Hello, I have a Summary sheet to have all counts of my sheets. I am trying to use this function: =COUNTIF(CHILDREN({Product Release Roadmap Intervalo 3}); "Complete") to have the count of the completed children tasks in anothet sheet named "Product Release Roadmap" but it is returning "Unsupported crossheet formula" Can…

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