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.

How to apply max function in smart sheet?
Good day everyone, I'm new to smartsheet thing and I keep searching at google for the correct answer but unfortunately I failed. I just want to get the latest date in another sheet. I found a formula online but it only get the first date match in a column. What I really want is to get the latest date value: My formula:…
Multiple Contacts Formula
Hello Smartsheet Community! I have a grid or sheet where we have listed out all of our projects in columns across the top and all of the supporting roles to each project down the left side. I have created a sheet to calculate all of these people but when I do the formula ( =COUNTIFS({CFPT Matrix - All Projects Range 3},…
unwanted break in formula which references another sheet
I use this formula to combine mutlipe dates and notes into a single string to display them by month. the dates/notes are in a separate sheet. the formula example is (where 'Davis October' changes depending on the last name/current month) ="October " + Year1 + CHAR(10) + IF(COUNT(DISTINCT(COLLECT({Davis October}, {Davis…
Formula to check a box when specific criteria are met
Hi! I am looking for a formula to check a box when specific criteria are met. I have multiple columns that have dropdown options. I would like the box to check when each of those columns have either "Approved" or "Declined" selected. But if "Submitted" is the option shown, then it should not check the box. So all…
User Email in Column instead of Name
Is it possible to get the Smartsheet user email in a column in addition to or instead of the user name? I'd like to be able to do a lookup on the email address. The email address is relatively consistent among various applications and names are not consistent. (I did search, but since the changes to help and community were…
Contact List - Extract First / Last Name?
Is it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there a way to only get the first name?
COUNTIF Function
Hello, How do I calculate the number of "completed" tasks in Phase 1 only? I figured out how to calculate the number of "completed" for my whole sheet but if I copy that formula to a new column in my metric sheet and highlight just the status column cells in Phase 1 then my whole sheet value also changes to that. This is…
SumIfs function with a date
Hello! I have a sumifs formula that works great: =SUMIFS({Amount}, {Branch Number}, Label@row, {Request Type}, "Maintenance") My problem is when I try to add a date aspect to this formula. I want to break this number down by month, so how much was spent at a specific branch by request type and month. I added this formula:…
Cross Sheet Formula Help - SUMIF, SUMIFS, OR - Which to use?
I'm trying to create a cross sheet formula that will track the dollars spent on items in various stages. I've easily created formulas for two separate stages, "Pending" and "Requisitioned". I'm struggling now to create a cross sheet formula that encompasses everything past "Purchased". This includes "Received", "In…
Help with If formula using Icons
I need your help to show status as Yes, No, Hold using this criteria: No - 90% + Hold - 51% - 89% Yes 0% - 50% This is my current formula, where the 'Yes' and 'No' icons show up as intended, but those that fall between 51% - 89% are showing the red X icon for No, not Hold. =IF([Resource Utilization]@row > 0.9, "No",…

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

Date format Formula
Hi All My Date column is formatted to YY/MM/DD - 2024-11-08 I have a week-ending column with the following formula. Returning the End day of the week that the Date column falls into =IF(OR(ISBLANK([Date]@row), [Date]@row = "N/A"), "", "WE- " + ([Date]@row + (6 - WEEKDAY([Date]@row)))) BUT the return looks like this WE-…
No Match...but the formula works
Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet… This is the formula: =IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA…
Auto sequential numbering even after moving rows
Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column: I have looked at solutions…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags