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.

RYG Formula
Good Day All: I am trying to add to my formula so that if the Due Date (Actual) is Blank/Empty, the RYG is Blank/Empty. My existing formula: =IF([Due Date (Actual)]3 > [Due Date (Planned)]3, "Red", IF([Due Date (Actual)]3 < [Due Date (Planned)]3, "Green", IF([Due Date (Actual)]3 = [Due Date (Planned)]3, "Blue"))) Thanks
countif current month
I was counting for current month. However, I keep getting invalid data type. =COUNTIF({Month}, MONTH(@cell) = MONTH(TODAY()))
Sumif with multiple assined to
We would like to create a list of all team members and the sum of their days on task for each team member, but we are having issue when there are multiple people assigned to one task. Each name should be only once in the list with the sum of the days. The result when summing up the table of our screenshot should be Rahul 7…
Training Plans - Central & Individual
Hello, I would like to build a central sheet that records training courses for my staff. These courses could be assigned to the group or to various individuals. What I would like is to have each individual to have their own training plan sheet, where they could add their own courses and track the courses I have assigned to…
Formula for date range
I am trying to calculate the total amount of invoices, from a given contractor, within a given date range. Im not sure how to write a formula to calculate within a specific date range. I have the formula to calculate the total invoices for an individual. But not sure how to insert date range into the formula. Here's where…
Using WEEKNUMBER() Formula
I'm trying to use the WEEKNUMBER() formula while calling a cell with a date in the format 07/17/19 and I keep getting an INVALID DATA TYPE error and I cannot figure out why. This is the formula in the cell: =WEEKNUMBER([Install Start Date]1) The [Install Start Date]1 displays 08/08/19 but is gathered from a VLOOKUP into…
If Function with Checkbox
I think this is simple formula - but can’t figure it out. I want a formula where if checkbox is checked, it puts the same amount as another extended column that I have. If checkbox 1, then take # from extended amount in same row and x1 in that cell. Does that make sense?
Automate RYG Balls when checkbox is ticked in another column
Hello Smartsheet Experts! Can someone show me a formula to use to automate the RYG balls in one column when a checkbox is ticked in another column? Green if checkbox is ticked and Yellow if checkbox is not ticked? Thanks so much for any assistance. ~Cecelia
Populate date fields per status changes
Hi, I am running into an issue with populating date fields per status change. I have two date fields that reflect per status change. For example: If status change to "option 1" change this date field to today's date. If status should change to option 2 change second date field to today's date. What I have currently:…
sumif parent row
I'm looking to find the the sumif of current week for a specific matter. However the matter is only listed in the parent row =SUMIFS({Test Hours}, {Week Number}, @cell = (WEEKNUMBER(TODAY())), {Matter}, =PARENT({Matter}@row) I keep getting an error in the formula

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