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.

=IF assistance (beginner/novice)
Good afternoon. Trying to state, IF Communication Column is "5 - excellent", then communication rating is a 5. I've written the code below however '5' is not populating. Any thoughts to the formula or should I make Communication column read 'Excellent' only that then converts to a '5' rating? =IF(Communication@row =…
Sheet Summary Formula HELP
Hello I am looking for some help with a couple of formulas in sheet summary. The first would be the best formula to use for a dropdown Yes or No column that I need to count if either is chosen? I have it where it will count if Yes but coundn't figure out how to add the No as well. =COUNTIF([CONVERT TO PLASTIC PIG]:[CONVERT…
Function to retrieve count in a multi-select column
Hi, So I have a multi-select column which upto 7 selections currently. What I am trying to do is have a bar chart of count based on the number of selections in each cell. To give an example. row 1 : A, B, C,D,E,F,G row 2: B,C,D,E row 3: A,C,D row 4: C,E,F row 6: A So what i would like to do is create a graph like number of…
How to count rows created in a specific year
Hi team - I have a sheet that has a date field called Issue Status Date. How do I do a count of rows that have 2019, 2020 and 2021 in the date field? So I need 3 separate formulas for counts by year but if I have 1 I can modify for the other years. Appreciate any suggestions. Thanks, Jeff
Delimiters
Hello, I have two formulas I am trying to add delimiters to but I keep getting an unparsable error. I am trying to join text in a few cells and have a space added between the text. Any help would be appreciated. Thank you. =([Teaching Preference:AFNR]@row + ["AFNR"]@row, " ") =JOIN([AFNR Teaching Preference]@row + [ASA…
Column Value Until Another Column Triggers Change
Good afternoon, We currently have our "BAC" column with this formula , =IFERROR(HTD@row / [% Comp.]@row, 0). However, we need to be able to change it so that the "BAC" column will equal the "BAE" column until the "HTD" and "% Comp." columns have values entered into them. Thank you in advance for your help!
Summing up Total Hours From a TODAY report
Good afternoon We have generated a report that gets sent to our foreman everyday , via a "TODAY" column, that they provide us with total man hours worked that day. Is there a way for us to be able to tally those hours in another column for a running total of hours from the daily TODAY reports? Thank you
Flag or Conditional Formatting?
I want a way to 'flag' a cell if it is out of range of two other cell dates. I haven't been able how to do that with conditional formatting because I can't set a condition to say if "this column" is NOT between "this column" and "this column" (where the dates change for each row). Is there a way to do that? I thought I had…
Copy folder for next year
Hello, I have dashboard and few sheets for input data from various files, how can I copy all this working for next next year, keeping the templates? should i put all the files in one directory and attempt to copy? but the files are from various folders.
Countif / Countm ?
Hello everyone, I take the liberty of contacting you because I am trying to count the number of times the name "Sophie" appears in a column. But you should know that in a cell can be several names like Robert Peter Sophie Léa... I tried this formula which seemed to me the most consistent :…

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

Issues with Numbering Children (Child 1, Child 2, etc.)
Hi! I am trying to implement a column formula in Smartsheet that assigns an ordinal number to each of the children in a sheet. For example, the first child would get a "1", the second child a "2", and so on. I've tried several options, and the one I liked the most is the following: Create an auxiliary column with a "1"…
Netdays calculation with optionnal date column
Hi i'm looking for a formula to calculate the netdays between 2 dates. but i have 3 dates in the equation. a date column (date 1) whit references from another sheet and a manual one (date 2) to overwrite the first one. the third date is the "today" date (date 3). so i'm looking for something like: netdays between date 1…
Formula to count in progress child tasks using % complete
Hello, I am trying to obtain the count for in progress tasks using my % complete column and excluding parent rows. The criteria I want to use: Count if Children = 0 (no parent rows) If % complete <1 and >0 I have the formula working for one value: if % complete <1. But I'm stuck on trying to get the formula to work with…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags