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.

Conditions / Rule formula set-up
I am working on a sheet, and I am very new to this application, where I am tracking P.O.'s, date ordered, date received, etc... and I have 2 columns (at the far right of my sheet or end) that I would like to If the P.O. Total is < or = to the Invoiced Amount the cell would turn green and if it was > than to turn the cell…
Duration roll up values not displaying accurately
My duration roll ups for child/parents are not working as expected. Can anyone advise of things I could try to resolve why only one parent has a duration total?
Furmula Not Working Properly
In the following Formula if I use ="Completed" I get the correct Count back. If I change it to <> "Completed" I get 0 returned where it should be 37. =COUNTIFS(Status:Status, <>"Completed", [Due Date]:[Due Date], >DATE(2018, 11, 25), [Due Date]:[Due Date], <DATE(2018, 12, 3)) Any ideas? Thanks, Bill
if - and formulas auto populating checkbox
I've created a column titled "Outstanding Approvals", I would like the column to auto populate the check box when "Approval Status" is empty AND when "Start Date" has already begun. I'm using it so I can pull multiple sheets into a single report - but not all the sheets have the same layout. Any help is great! thanks in…
Date formula question
Good morning, we have a sheet we are using to track leads. I've been asked to set up an automated update request to send leads that have a certain status out on the first business day of each month. In the automated actions, there is no way to set a recurring update request like there is on the row-level update request. So…
Using SUMIF Formula Help
Hey everyone! I just started using Smartsheet and so far am blown away by everything! At the moment, I'm trying to use the SUMIF formula to calculate a total cost but only if the number being used is below 0. For example, If Column A is a negative number, I need the formula to subtract it from Column B, however, if Column…
Formula that will automatically add $25 to the cell
tracking installations of certain units. When unit install gets cancelled checkbox for "unit cancellation" is checked. What would the formula be that when the cancellation box gets checked it would automatically fill in $25 into a "trip charge" column? Thanks!
Date
Hi! I have a tricky formula I'm trying to calculate, but with no success so far... I have to different sheets that I'm looking on. Sheet1: Planning and monitoring sheet Sheet2: Work reports The formula challenge: In Sheet2 our guys at the field are reporting on different predetermined projects. They report which date they…
Sum rows if shared value in another column?
Hi, I'm trying to summarize hours worked on each project for each month. My list of projects changes regularly with some coming in and some going out. Data is collected weekly so there will be multiple entries for each project. My thought was to SumIF the project identifier matches. I'm new to Smartsheet and have searched…
TODAY() Function is Replacing Previous Date
Hello, I have a column in a production spreadsheet that I am utilizing to enter the date of which one of our production members completes an order. The columns are set up as follows - one column is an initials column where a production member selects their initials once they complete an order. The second column contains…

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