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.

Summing IF and After 7
Hello, So I don't even know if this is something I can get a formula to do, but I am trying to get a number to check a cell reference and start summing if the number is above 7. But here's the kicker, I don't want it to sum the entire amount. I want it to essentially sum the number, minus that 7, but only sum the numbers…
Duplicates
How do i create a formula that shows there are duplicates. I would like it to have a check box in a column showing that "Sarah Jensen" has duplicate expense submission based off Consultant Name, Date of Receipt,Total Expense.
nesting If. Can't figure out why I get unparseable error
Here is my formula. It is in a project plan: =IF(TODAY() > [End date]1, [% Complete]1 < 100%, "At Risk", "On Time")
Help With Getting a IF statement to work when using columns referenced from another sheet
Hello all, I have a sheet that I'm trying to get the elapsed time in days from when a ticket was open to when it was closed. I am doing this using a second sheet, so the formula uses sheet references. I am having trouble getting this to work when using a range of items. When I use the COUNTIFS function, using areferenced…
Converting result from an Index & Match formula from date to text
Hello all, I am trying to work on a formula to make it easier for me to work on Global Updates in Control Center easier in the future. I currenly have a formula that coverts the data from Date to Text instead of just a simple link to the (lets say) the Start Date column; I had to do this because of the Global differences…
Cell formula that will highlight a task expired if any of its sub tasks are expired
Hello All, I'm trying to create a cell formula that will highlight a task expired if any of its sub tasks are expired. For example if a parent task has any child tasks with due dates earlier than the one of the parent it should be marked as expired. Is there a formula available for this? Thanks
VLookUp and Multiple Rows.
Hi, I'm pulling two excel sheets into SmartSheet. Sheet 1 is called the MASTERLIST Sheet 2 is Called the SALESFORM. The SALESFORM pulls data from the MASTERLIST. What I want to happen is in the SALESFORM I enter an Item Number that is in the MASTERLIST and data from that row fills in in the specific spots. Example. Item…
Project sheet - with multiple duration columns
Hello I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date. Screenshot as below. Appreciate any help to solve this issue. Regards Daniel
VLookup with multiple requirements
I have read several community threads already, and can't seem to find what i am looking for. I have a Vlookup table that includes Pipe Type (Copper or SCH 40), Pipe Size (1, 2, 4, 6), Pipe OD (Different OD based on Pipe type) in 3 separate columns. I want to show the Pipe OD Based off the Pipe Type and then Pipe Size. I…
IF/OR function
Hi All, I am trying to create a formula (assuming a combo of if/or is the way to go), but keep getting "incorrect argument set. They work independently, but not when I combine them. I basically want to search for either of the following in a cell and then return a value. Look for any of the following in one column: *…

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