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.

Having trouble with an Index Collect with multiple matches?
Hello all, please let me know if this makes sense what I am trying to accomplish as I have been stuck on trying to get a fix for this. I am working to create a sheet that looks at an export out of a dsp and checks to see if those are elements match with the information in our smartsheet - kind of like a QA sheet to do…
Shorten numbers & format to display thousands as "K" , millions as"M" but still remain as numbers
Hello everyone, Good day. I'd like to ask your help regarding a task I'm trying to complete on Smartsheet. I'm trying to shorten the numbers in a table show thousands with "K" and millions with "M" after the first comma instead of showing the entire number. I found the thread below and it gave me the rounding and…
Mail Merge to Google Docs Date Format Error
Hello, I'm driving myself crazy trying to find a more efficient workaround for this issue. I'm open to any help. I use the SmartMerge add-on to create a mail merge document in Google Docs. It has worked beautifully except for the date format once the document is merged. On my SmartSheet, I have the date in the following…
=SUMIFS formula with 3 criteria
Hello, currently I have a working SUMIFS formula adding revenue from column A based on the status in column B, so my formula is: =SUMIFS({Revenue Column}, {Status Column}, "Completed") But now I have a master data list that separates projects into internal and external, I need to add to my current formula to only count…
How to count values in drop down
I have a training tracker that Managers complete the form to then update the tracker. However I want to be notified when 10+ students have registered for the same course. I will add some screen shots but i.e. if more than 10 ppl register for "Auto" then I would like a count of how many. I added a column per Module but then…
Hi! This one might be tricky... Help with T-Minus Formula *First time posting!*
Hi! I am basically looking for a formula that will return me a "T-2" result. For example, a product is launching on 12/31/2025, and XYZ activity is taking place 01/31/2025. Ideally, the formula would tell me it's T-11 from the launch. Does anyone know how I could solve for this?
Form Submissions: Multiple Condition IF Formula Isolated to Most Recent Only
Hello Friends! I have a form that my field crew uses to check the condition of our machines every morning, which includes the most recent hour/meter reading. There are (5) machines that we own that I want to isolate the most recent reading into a dedicated cell in order to determine how soon the next service will be. Also,…
Need Help with a Formula
I'm trying to create a formula that says if the date in the "due date" column is between 60 and 90 days from today, mark yellow I've tried a few things but can't figure it out. Can anyone help?
Equation to fill in "On time" or "Late"
Hello, I am trying to create an equation that will generate on time or late depending what the quoted delivery time is and the real delivery time is. I have been able to get thus far but I want to include a parameter so if it is 5 minutes or less late then it will say on time. For example if a quoted time is 9:00 and the…
Formula Question
I am using this formula to calculate the % of budget used to date on a project: =[Actual Hours]@row / [Planned Hours]@row. Some of our projects do not have the planned number of hours. In this case the cell for planned hours would either be 0 or NULL and I would like the % of budget cell to display: "No Planned Hours…

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

VLookup help
HI. I need to look up a # based on the entry entered in one column. I have established a look up table, but having a difficult time with the formula. example - I enter ACME Supplies and I want it to look up the vendor number in the table and return the value into the corresponding field.
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags