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.

Is there a way to use SumIF to add values in a column that match a specific text string in adjacent
We are building estimate sheets using a hierarchy based on Construction Specifications Institute's organizational coding system. I have rows nested using multiple parent / children. The top level is the CSI Division, which has children rows with specific categories within that Division, and each Category line has nested…
IF(INDEX(MATCH formula
Hey folks, Thought I'd reach out to see if anyone could assist with my IF(INDEX formula. The columns involved with this one are Today's Date, Date2(abbreviated name for the day), daily sales qty's. I have a Dashboard where I return/display the Qty for the previous day's sales. My issue is, the formula in it's current state…
Formulas
Is is possible to write a formula based on information in one sheet to put the result in a cell of another sheet? I want to sum items if they meet certain criteria in one sheet but the result going in a cell in another sheet. Thanks!
Date Formula Needed
Hi, I am trying to subtract two dates and have it return as the number of years. I have not been able to find any "date" formulas that will work. Any ideas? See screenshot
Auto Date Calculation
Hi Very new to SmartSheet, I am trying to create a Purchase Tracking sheet that can be used for Payment Schedule. Here is what I have " Invoice Date" This I put it manually whenever I receive an invoice from my vendor. I also have another cell "Droplist" which state payment terms like 30/60/90 days. What i need is 1) A…
How to ignore blank cells within formula?
Hello, i have a formula which checks compliance between two dates (if one is greater than the other then it returns ‘no’, otherwise ‘yes’). Please could someone help me to update the formula to leave the result blank if the value in one of the other cells is blank? Currently it’s saying ‘yes’ when there’s no finalised…
If Function ERROR
=IF(AND([Term length (Years)]@row >= 1, [Term length (Years)]@row <= 5, Referral@row = "External"), 0.03, IF(AND([Term length (Years)]@row >= 6, Referral@row = "External"), 0.03, IF(AND([Term length (Years)]@row >= 1, [Term length (Years)]@row <= 5, Referral@row = "None"), 0.07, IF(AND([Term length (Years)]@row >= 6,…
NETDAYS based on IF statement
I'm trying to use a NETDAYS function to determine how many days overdue a payment is, but I only want to display that number of days if a column named 'Status' has the value 'Client payment pending'. The function I'm trying to use is =NETDAYS([Date Sent to AP/CR]398, TODAY()) but I don't know how to work that into a…
SUMIFS - Contains value in cell from another sheet
Hi All, I want to create a "Total Vendor Paid Amount" column on our "Main Dashboard". This column will need a formula that pulls information from another dashboard called "REO Vendor Invoicing (3)". I want the formula to sum the total invoices paid, in the "REO Vendor Invoicing (3)" dashboard, of jobs that contain a cell…
Countif - Want to count number of times a word appears, multiple then divide by a certain number
I'm creating a pricing sheet and need to use the countif formula. I am counting the number of times "High", "Moderate", "Low" appears in the column and times by 3, 2 or 1 then dividing it by the total count. For the sake of space, I named my column "G". Not sure if Smartsheet recognizes the "+" in the formula…

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

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags