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.

Sum of a column based on multiple factors
I want to take the Sum of Column A from another sheet if column B shows "Loan Declined" and Column C shows either "Underserved" or "Low-Income". I tried the following formula to achieve this but none of them are reporting the needed information: =SUMIFS({Column A}, {Column C}, "Underserved", {Column C}, "Low-Income",…
How can I automatically remove data with a value of zero from a Dashboard
I am looking for a formula to remove any line of data that has a value of zero in the Report, from the Dashboard. So, when the line of data is zero in the Report, it should eliminate that row from the Dashboard.
Formula issue
Hi Can I ….. So in my Traceker Sheet- I want to return a co- ordinators email when the relevanant team is selected - when "White Collar is select in the Tracker sheet, return the correct Email from the data sheet
IF Formula Help
=IF([% Complete]@row < 0.1, "Not Started", IF([% Complete]@row > 0.1, AND ([% Complete]@row < 0.99, "In Progress", IF([% Complete]@row = 1, "Complete")))) I need help with this formula. I need the row to say Not Started if % Complete is 0%, Complete if 100%, and In Progress otherwise. Help Please!
Sharing data among multiple sheets
I've created a sheet for the company to manage all Contacts. In a new sheet to capture more data about orders for a company, we would like to be able to pull over name and email address of a Contact when the Organization name matches in both sheets. I need this information to always be accurate in linked sheets when…
Formula to uncheck a box
Hi all, I have a project sheet that I need some help with a formula. The sheet has a checkbox called To-Do and a % Complete. All tasks start with the To-Do check box as unchecked. If the user needs the SME to act on that task, they check the To-Do box. I then have a report sent to each SME with their "To-Do" list. The SME…
How do I fix my IFERROR(INDEX) formula to pull data from a single sheet?
I'm trying to pull publishing locations from a column in a sheet using Project ID. The first part of the formula and last part of the formula seem to be okay, I get the "Edit" option if I click on them, but the MATCH portion is giving me the "reference another sheet" message. Here is my formula: =IFERROR(INDEX{CE&T ARCHIVE…
Task Bar Automatic conditional formatting Dynamc view vs Grid view
Hi, First of all, we would like to remove the Task bar automatic conditional formatting as soon as Entire row is selected, as we prefer not seeing this highlight each time Actual date matches the Baseline. Is it possible ? If impossible, I have tried to select each column independently instead of "Entire row", but, in the…
Calculating Overdue days
Hi, Am using formula [ =TODAY() - [Due Date]@row ] to calculate overdue days, which is working fine but when the date is in the future it's showing me [ - ] minus sign and days (example [ -2] ). Is there a way to have [ +2 ] if date is in the future. Thanks in advance,
Calculating a number of days from a start date but stop when there is an end date
Hi, I have a tracker sheet for applications that come in and we need to be able to calculate the days when they come on hold. There is a formula already for when it first comes on hold being =TODAY() - [On-Hold 1 (Start Date)]@row but when we receive the correct information we need to take it off hold and would like to the…

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