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.

Formula Autofill not Working
This discussion was created from comments split from: Automatically add formula to new rows.
Help with Formula: COUNTIFS using date range and single dropdown data
I'm trying to figure out a formula to count how many projects occur within a specific date range as well as have one of three different payment status'. Here's my working date range formula. I'm trying to AND the date range with the three OR'd payment status'. =COUNTIF({EISD}, AND(@cell >= DATE(2021, 5, 1), @cell <=…
How can get the most recently register of FSE from table 1 and send the name of FSE to table 2
Mi situation is that need review int the table 1 who have the 280.1 and once i identify the most recently register need send the name of the FSE who has the 280.1 to table 2 Table 1 Table 2 This I need
Presenting N/A or Entering Date in Reports
Hello, We are attempting to come up with a formula that will present N/A in a Date column if the parent column lists N/A, otherwise we want the date functionality to work by presenting a calendar the user can select the date from on their individual report. What we are running into when the report is created is that the…
IF/Then function or Index/Match function...unsure of best route
I need to create a function where we have a lead with assistants working under them, and are needing to calculate the total of their office size. If the assistant(s) are a SHARED resource, their value is 1, regardless of how many shared assistants are dedicated to that lead. If their assistant(s) are dedicated to their…
How to edit this formula to start my day at 6:30am.
Hello, I am using this formula to count my fiscal week and it works just fine, but every Monday at midnight, it switches to a new week. I need it to delay the change until 6:30am. How can I edit this formula? =ROUND(((Modified@row - DATE(2020, 10, 25)) / 7) + 0.49, 0)
Coding for Health symbols
I am BRAND NEW to Smartsheet and am looking for a way to code my sheet so that whenever a new entry is submitted via the form, the Health Status symbol is automated to the color Red? I also can't seem to change the color of my forms no matter what I choose to do in the Colors and Logos it always ends up White! Much…
Current Week and Next Week Formula
Hi, I need help with a formula that will help me determine if a date is the current week or the next week in the calendar. Need the weeks to star on Sundays. I'm using the following two formulas: For Current Week I'm using the following formula, which is working fine: =IF(AND(YEAR(TODAY()) = YEAR(ChangeDate@row),…
I'm Stumped - Need a Percent Average when applicable
I have tried a number of ways to get this to work, and my hunch is I'm needing a percent average from other percent averages (where some may be an iferror result that needs to be unaccounted for). Attached is an image of the work. I need the average percentage of projects on design schedule for those with projects in…
Count if date range
I am trying to create a formula that will tell me how many tasks that contain Map that are Flagged for CSO responsible that are due in 7 days, 14 days and 30 days from the Current Date or Revised Date (whichever is the great of the two)

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