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.

Returning a cell value if false
Hello all. Pretty new to Smartsheet here. I am trying to create a call that checks if one column, Trip, contains a value 1st, if it does NOT contain the value 1st, I want it to populate the contents of the corresponding cell in column Job Description. I keep running into errors attempting to nest the cell call =[Job…
Showing multiple true checkboxes as joined or concatenated text in another column
I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person/row without tons of scrolling and looking up and down at column titles, I want to aggregate…
ISdate or ISblank
I'm trying to achive this: Field Maintenance: If my field Last maintenance date is empty, i need to put today's date, if there's a date i need to put Last maintenance date + Frequency (day) Not able to make it works with isblank or isdate, any other idea? thanks
Conditional Formatting
Hi I am hoping someone might have a simpler solution than the one I am thinking of. I am creating a sheet for my company to track all of our projects. The scope of what we do for each project varies based on what kind of campaign it is. There are 10 different kinds of campaigns, so say for example Campaign Type A might…
Linking Sheets
I am working on a master SmartSheet to roll up other Sheets into one. When changes are made in the linked SmartSheets, this is not reflected in the master. If I add additional rows, my master is not updated What I am missing?
Count specific total number grand children rows and ignore higher rows
Hello All, I am tracking different sessions being hosted between employees. The sessions are the rows with the white background. I want to dynamically count the total number of sessions that are happening for row 2 "IMC". So I need to count the number of children of row 3 "IMC Common Architecture" as well as the number of…
New UI 12-14-2018
This UI is terrible, I don't even want to waste my time explaining why at this point, it is OBVIOUS. At this time I am contemplating updating all training materials, SOP's and videos or just throwing in the towel and searching for a replacement. I simply do not have the time to re-learn, re-document, re-train every time…
Score Formula
I've created a scorecard in smartsheet and want to create a formula that does not allow the scorecard score to show as more than 100%. I think is should be something like If score >100%,100% but am not sure what the entire formula should be.
Linking smartsheet
I have a master sheet that I am using to pull in data from the child sheets (linking). The child sheets are dynamic and new parents and childs could be added. 1. When linking i lose child sheet hierarchy on the master sheet. How do i maintain hierarchy? 2. When new tasks are added (with hierarchy) how can i keep the master…
Identifying and returning phrases within a single cell
Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help! I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water bottle, earphones, bag."…

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