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.

How to Record Date & Time When a Checkbox Is Checked with VLOOKUP
This discussion was created from comments split from: Formula to copy the information of one cell into a different cell.
SUMIFS Exclusion Criteria Causing #CIRCULAR REFERENCE Error
This discussion was created from comments split from: SUMIFS excluding criteria.
How can I combine rows?
I have 1 sheet with 3 forms. As the project goes along, 1 individual will complete each of the 3 forms. This will generate 3 separate rows on the sheet. I want to combine the data from all 3 rows into 1 row. Can this be done?
How can I change this formula to exclude holidays?
I have set up a project status report to automate expected deadline dates for certain project deadlines. My current formula excludes the weekends, but not holidays. What can I change/add to this formula to do so? =IFERROR(WORKDAY([CD Kickoff (E)]@row, +1), "") Also, if I need to have the dates counted by 4 weeks vs days…
I have a formula that works, but for cells that should be blank, it shows INVALID DATA TYPE.
I've tried the IFERROR and that is not working. It's a simple formula to count the dates between when the Case Manager was supposed to sign the form, to when they did sign the form. =NETWORKDAYS([Document Signed Date]@row, [Document Signature Required Date]@row) As soon as I make it a column formula, it shows all the cells…
Need a formula to count number of days past a deadline if the work is not complete
I have the following fields: Document Signature Required Date and Document Signed Date. I need to have a formula that shows the number of days from Document Signature Required Date until today, if the Document Signed Date field is empty. So basically, if there is no completed date, how many days has it been on hold. I've…
Formula not returning the correct values
I'm having a bit of a weird issue. I have a helper column that is supposed to return values that are pulled for a metrics sheet. Overall the formula is working, but it's like its not moving past the "Materials Delivered to Vendor" part. =IF([GM Status]@row = "PO Created", "Written", IF([GM Status]@row = "Delivered to…
Date Formula
Hello is there a function where a date can be calculated based off a selection from a drop down in another column. For example, if someone selected a status saying "In approvals" which takes 5 days to complete can Smartsheet calculate 5 days from today's date and display that date in another column?
Help with COUNTIFS and NOT CONTAINS formula
Hello, I have looked for this all over the smartsheet community, and while there are some responses, I still cannot get this formula to work. I need assistance with the following: I am looking for a count if of all "low" priority from one column on a referenced sheet that are not "complete" in a different column on that…
Automating the Documentation of Historical Values without Workflows
Problem: How to automatically document historical values without using the automation workflow. I have a two-line graph of which one line (let's color it black) represents desired results within a date range. This date range ends in the future. The second line (let's color it red) represents actual results within the same…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Sum a column associate with children
I have the following layout, and I am trying to sum the "Ordered QTY" column for all children within each parent in a helper column so I can verify that amount with the parent "Ordered QTY". Any help would be appreciated and thank you very much…
Formula Help
If I want to compare column 2 of Sheet D to column 2 in Sheet F, and return the value from column 1 in Sheet F to column 1 in Sheet D if 2D and 2F are equal, and not return anything if they are not equal, how would I put that in a formula? I think it's a vlookup but my formula didn't work.
Reporting & Metrics
Typically we try to use a report to update our Hypercare Ticket Log. This strategy helps us maintain a clean log and keeps the noise down. What we are finding though is though all members have "Editor" rights in the report, they are not able to create filters or sort the report when they are working. The report needs to be…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags