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.

If/countif returns incorrect arguement
So I'm using the following formula and getting errors. =IF(COUNTIF([ID Dump]:[ID]), "CURRENT", "NEEDS") Basically, I'm trying to get a return of CURRENT if any of the values in the "ID DUMP" column are in the "ID" column, and then a NEEDS if the number in the "ID DUMP" is missing. I used the following formula in excel and…
remove file extensions from cell
I am pasting in a bunch of file names into a column (ID_Dump) and need to remove the extension ".png" from the cells. How exactly would I accomplish this? Also, not sure if it makes a difference, but I have another column (ID Checkbox) referencing the ID number in it's row (ID) to see if it's anywhere in the ID_Dump…
Tagging people in comments in Dynamic View
i've noticed I cannot tag people in comments using Dynamic View. Is this because they may not be shared to the main sheet? The whole reason we got DV was to limit access to the main sheet!
Vlookup on a cell with a formula
Hi, Is it not possible to use a vlookup formula on a cell that contains another formula? I tried and I get "no match". This is the formula I tried. There is a match in my lookup table for Map ID 2. I have double checked. Thanks for any help!
Date Formulas
Hi everyone, I can't seem to figure out a formula to automate dates. I have a "Due Date" column and a status column. In the status column I would like to say that if it's passed the due date, the status column should say "Overdue" and if the due date hasn't been reached yet, it should say "In Progress". I've tried to use a…
Calculating days past due when comparing two columns
So I am trying to compare two columns. If the Revised Release Date is blank, then look at Planned Release Date -Baseline and determine how many working days we are past due. If Revised Release Date is not blank, use that field to determine how many working days we are past due. I've tried this formula as I thought my logic…
Trouble with COLLECT in INDEX/MATCH
I'm trying to troubleshoot an INDEX/MATCH formula that contains a COLLECT statement which is supposed to limit what cells are being used for the MATCH. I am referencing a project schedule, looking for the "next deliverable" - we have a column called "Function" in which the schedule tasks can be defined as such. (See…
countif - amount of damages per week / month
Hallo, I want to show the amount of damages per week / month. Do you have an idea for a formula ? I use "Schadeneintritt" (=date of damage) with date as column type
Hi, My Cross Sheet formula =IF( is displaying the same results when I drag formula down dest column
Hi, When using the following cross sheet formula (see below) it appears to pull the data correctly from the source sheet (top pic) into the destination sheet (bottom pic), however when I drag the formula down it populates the same information - I'm using the Equipment Name as an example. As you can see in the source sheet…
sumif - total costs open damages
Hi, I wonder what is wrong with this formula ("unparseable") =SUMIF([Kostenschätzung / Zahlbetrag]:[Kostenschätzung / Zahlbetrag]; COLLECT(Bearbeitungsstatus:Bearbeitungsstatus); <>"abgeschlossen")) I guess you will find my fault... ;-)

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