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.

Trying to logically evaluate a COUNTIFS statement and failing
I am trying to set up a formula to evaluate a summary status based on whether any open risks or issues on a log are rated as 'High'. I have a COUNTIFS statement that correctly evaluates how many high scoring issues I have and a similar statement to count high scoring risks. I am trying to write an IF statement to rank them…
JOIN Function
I have followed all the instructions but really struggling with this. I am trying to show items from several columns in Calendar View. I read this can be done using Join Function for the primary column. I used the same formula and was able to get it to work for two columns but when I attempted to add more I get an error.…
Automatically Counting All Drop Down Choices
Hi, I have a drop down column with different names and this across multiple sheets. I would like to be able to know at all times how many times these names appear across in my rows across the sheets, and if a name appears more than say 65 times, be alerted. I have a sheet summary that leads back into a report currently,…
Filter by Week
Hi, Relative newbie here. Im creating a smart sheet for the maintenance planning and scheduling at my work. The idea is that once jobs are planned they can be added to the sheet, and with filters made set by week number IE week40....... Easy enough The problem I am having is if a task duration is 3 weeks long as an…
Count items due in future weeks - not # of days from now
I would like to count how many items are due a specific number of weeks from today. Example paraphrased: If today is Wednesday 9/16/20 I would like to know how many items (based on Due Date) will be due in the second work week from today. Sept 28 through Oct 2nd in this case. I know how to find items due in the next 14…
RYG Formula
Hello all, I have a sheet with some conditional formatting that changes the color of the row depending on "Date Expires" date. I would like to add a formula to add RYG as well and was hoping someone could help me with the said formulas. Below is what I would like to accomplish: Red if the date in "Date Expires" is in the…
Help w/multiple column criteria summary report
Hi team - I've got a sheet with over 100 columns and only specific columns are "mandatory", indicated by an (M) at the end of the column title. There are several more columns to the right of this graphic - some with a "mandatory" column and some without (meaning there is no "mandatory" helper column for the question for…
Using the OR and AND Function together
I have a checkbox that I need to have checked if the Due Date Field is less than today and the Status does not equal Completed or No Longer Required. I've tried multiple combinations of formulas and I have not been able to figure it out. I need some help. Here is the formula that I currently have. =IF(OR(AND([Due Date]15 <…
Percentage Formula
Has anyone built/used a formula to capture the percentage of specific responses in a series of questions? We're experimenting with Smartsheet Forms to be able to administer an exam. Each column would be a single-select dropdown of the multiple-choice exam question format. On the backend, we want there to be a formula…
Status Colours - comparing dates
Hi Quite new to SS, but have been tasked with trying to update a current sheet to show a colour status column. I have 2 columns which hold dates, with some of the data been pulled in from other sheets, thats need comparing. If someone can help with the formula to show Green, amber, red status dots depending on the below…

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

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags