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.

Sequence Duplicate Number
is there any formula to achive this kind of output? Im referring to count RFP ref duplicates
Calculating average on linked cells - divide by zero error
I have linked 2 cells from another Smartsheet that are child tasks to my project plan. When trying to average the linked cells in the parent task, I am getting a divide by zero error. The linked cells are not showing 0 in their calculation. I'm at a loss. My project plan showing the linked cells and avg formula. I'm…
trouble shooting a range
a series of references have become invalid? not sure what has caused this but i want to walk thru the formulas and make the corrections how do i see a range? i see it being called in the formula but i cant figure out how to go to the range and be sure its still valid
How to make a report that includes only dates within the past 60 days?
When I set up my report using "is not in the last (days)" then add 59 after it, the report is considering blank dates as true. I need it to ignore blanks. I need the row to be in the report if any one of the dates is past that point. The ones that are blank are due to the person not being trained in that area.
Formula for totaling 2 selections from a drop down in sheet summary
Hello,I am trying to write a formula for my sheet summary. I would like a formula that gives me a total number when Instructional Design and Learning Solutions is selected. I have been successful with the countif formula when I want to count just one criteria but not two.
#Invalid Ref using Marketing Campaign Management Template
I used the marketing campaign management template and created a new campaign, however under my campaign Info sheet I am getting a #invalid ref on all cells. I have verified the formula is correct and the range (using the sample campaign as a guide) and am at a loss. Because of this error the information on my campaign plan…
Simple subtraction formula not working when number goes negative?
Hey, im trying to create a formula where my sum will at times go negative. the plan is to highlight cells that go lower than zero. For some reason the calculation is wrong. 62195 - 72000 should =-9805 the result im getting in smartsheet is 4195 anybody know where i went wrong?
Contact Field
Hi Team, I haven't fully tested by running an alert on the field but was wondering if you can confirm this looks correct. The field type is Contact and need 2 email ids to be populated in this helper column so I can sent an alert to them each time a request gets created. =IF([Vendor Type (please confirm with vendor)]@row =…
Move data from the left most cell
So I have a smart sheet that contains 4 names in a row. I need a formula that will copy the name from the first NOT blank column to the senior member column: Grandfather Grandmother Father Mother Senior Member Bill Anna Charles Bonnie Robert Mary Jordan So the first row senior member would be Bill, the second would be…
VLOOKUP or IF?
Hello, I am not sure if I should be using VLOOKUP or an IF/THEN statement or a combination of the two. Any help is greatly appreciated. Thank you. Problem Statement: I want the PWS link to auto populate based on the Areas of Support selection. Both columns are dropdowns. Current attempt gives me a circular reference.…

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

Get a Countif on values in a multi-select column of cells
I am trying to write summary formulas to determine how many values appear of each in the drop-down of a column. I tried adding a wildcard, I have tried HAS, and tried CONTAIN, but I'm still not getting the right values. Currently I am getting 0 as a return value on this formula: =COUNTIF([ROI Type]:[ROI Type], HAS([ROI…
summaries in report
Hi i'm trying to build a report with summaries options. i have two column that i want a Min and Max summary. the column for the Min i a texte column and works well. but the other column has formulas and the Max doesn't works. there is a way to fix that? (instead of creating another text column in the source sheets?) here…
Converting email addresses with hyphenated First and/or Last Names
I am trying to convert email addresses into a Name field with the employee's First and Last Name, capitalizing the first character of each part of the name and keeping the hyphen in any part of the name that has one. I started with hyphenated first names so taking shmoe_joe-bob@company.com and converting it into Joe-Bob…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags