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.

COUNTIFS 4 variables
Hi, I need help with this formula. As you can see I am hoping to count when the name: Category Management is found in FUNCTION 100% is found in PERCENT COMPLETE S-CL is found in PERIOD and Day 1 is found in PERIOD Goal is that if all attributes are found, the count and provide a total. My formula is below.…
How do you count the number of blank cells in a column?
Hey I would like to use a formula that counts the blank cells in a column. It should be a simple formula, but for some reason I can't manage to get it right. Kind regards, Jana
COUNTIFS + FIND Question
Hi I am trying to figure out how to count the number of times during the week that there is a revision to a project. The revisions are figured out by looking at the Estimate #. If the Estimate # has an "R" in them then I need the formula to count those. The current formula that I have is:…
Make on weekend as working days
I need to make one weekend as working days in my project. I don't want to create a parent task with sub tasks. I want to force the weekend to be a working days. I appreciate your help
Finding Duplicate entries across three columns
I am working on our departments budget worksheet that is linked in with our Finance department. I have found that entries are being duplicated and can not figure out why. They have the same time stamp and information. There are 2 columns that I am cross referencing and sometimes 3 to find these duplications. I have tried…
Counting Items mentioned once in a multi drop down option
How do I have on a tracking sheet where as long as the item is mentioned in a multi choice cell, it counts that item I am requesting? "At Risk Associate" needs to show 4 times, but doesn't show anything. I use COUNTIFS and tried HAS but nothing has worked.
set health based on multiple status columns
Hello! I appreciate your help! I would like to have a health column that is based on the status columns. For example, if three of the tasks are in progress, but one is delayed, I want the health column to be yellow to show a risk. Is this possible or does the symbol need to be based on input from a single cell? Thank you!
Formula to remove duplicates in a column
I have a column Project in sheet with same value multiple times..would like to remove the duplicates and show only the unique values as under Result in dash board or report. Can any one advise the easiest way..thanks
Formula for Late Audits
I ma trying to create a formula to display "Planned", "On TIme" or "Late" depending on the following criteria: If Date Completed is blank and Date Scheduled is greater than "Today" - Planned If Date Completed is earlier than or equal to Date Scheduled - On Time If Date Completed is Blank and Scheduled Date is Less Than…
Help on SUMIF Formula not showing a negative value
I know this has to be something simple but my brain just can't get done this morning, so any help is greatly appreciated. I basically need a formula to take one cells value and minus another cells value if one cell is greater than 0. This is the formula ------- =SUMIF([Actual Device Tags]@row - [Quoted Device Tags]@row,…

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