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.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Blank Rows
We have a simple ticket tracking sheet. It consists of a couple dozen columns and one form. It don't use any hierarchy, so all rows are at same level. There are several columns that use formulas - some cross sheet vlookups, some date calculations, turnaround time, etc. Nothing too complicated, however, the formulas in…
Regular project updates
I have a sheet and want to automate a request to assignees to provide an update at the same time each month. How can I do this without a due date and a formula driven checkbox or flag that would trigger the request?
IF, RYG and range
Hi All, I'm growing absolutely desperate. I have gone through what feels like a milion various posts on here, but nothing quite seems to answer what I need. I am trying to set up RYG conditions based on monthly estimated FTEs so that if the FTE is higher than 1 in any of the columns, the ball goes red. And I am wondering…
pin the home or recently opened menu
I would love to be able to pin the "recently opened" or home menu to the left of the screen, so it stays open while I am in a sheet or report. There are frequent occasions where I want to be able to navigate around and it requires extra clicks.
I need to trigger an update request 2 hours after the date time in a field - can anyone help?
I have a date time value in a field like this 11/04/202016:00 when it is 2 hours past this time I need to send out an update request. Any ideas...I cannot find a way to do this. thanks LuAnne Tiangco
Automation
Gurus-- I had an automation set up to send out an update request when a new line is added and the box is "unchecked". It will send to a list of emails I have listed under Operaters. It was working and now it's not. This is my set up. Can anyone tell me what I am doing wrong?
Countif and contains formula
Hi Help Community, I'm trying to create a formula that counts if criteria are met in two columns: point of contact and fiscal year. The Point of Contact column is a multi-select so I think I need to use "CONTAINS" in my COUNTIF formula but I'm not sure how to do so. The Fiscal Year is a single select. Here is what I am…
Is it possible to tweak COUNTIF to count everything but a certain criteria?
Here's my function that works when conditions are met: =COUNTIFS(Name:Name, CONTAINS("Open", @cell), Location:Location, "TBD") How can I adjust this so that it works when I want it to count cells where locaton isn't "TBD" -- putting in all the options of possible matches isn't feasible. I've tried the NOT funtion, but must…
My Formula looks incorrect
Hello, I am attempting to get a Margin (%) for my outcome, however I have received "unparseable", "incorrect argument" "invalid" when attempting a few variations. Am I overlooking something? I need to get my The formula I am using in smartsheet: =IF(ISBLANK([Customer Cost/Booking $$]@row - [Partner Cost $$]@row), "",…
How to calculate # of Working Dates from Start Date to Today if there is Text in another Column
I'm trying to see how many Working Days has passed from todays date when there is a Date in Project Start Date column and the # of Days from Project Start to Baseline column is "Not Yet Baselined". If the # of Days from Project Start to Baseline column has a Date then # of Days of non-Baselined to Today should say…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Can I copy a row to another sheet more than once?
Is it possible to copy a row to another sheet and have it copy multiple times on sheet #2? For example on sheet #1 I have a project with multiple dates for different deliverables within the overall project. I need these projects to copy over to a 2nd sheet where we get a separate line for each date. Right now we are…
Trying to determine if all children have N/A Status
I'm working on a formula for summary rows to look at the % Complete of the row as well as the statuses of the child rows. I have the % Complete portion handled: =IF([% Complete]@row = 1, "Complete", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 0, "Not Started"))) I want to add in…
I am trying to manipulate my SUMIFs Formula
When Using SUMIFS(Range, Criterion Range 1,Criterion...) I have multiple columns for example Estimate Spend, 25% spend, 50% spend, Rather than having multiple %'s of spend I just want to be able to use 1 reference and multiply it by 0.25 or 0.5 in the first "Range" category so =SUMIFS({Spend} * 0.25, {Phase}, "phase 1",…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags