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.

Obtain values based on 2 criteria in another row
Hi, I hope you guys can help me out, For the sheet below I would like the Downtime Start Date and Start time to be copied from the "New Job" to the "Follow on Job" IF The Job number in the "Follow on" row is the same as the Autonumber of the "New Job" and for the values (Downtime Start date and Start Time) to be put in 2…
SUMIFS formula for invoiced to date and to be invoiced
I have 3 cells in one row. Each contains a percentage of the total amount of the line to be invoiced. We invoice the first 25% at initial submittal to the client, 50% at the 2nd stage between 30-90 days later, and the final 25% 7-30 days later. I need a formula to add the 3 cells together if the corresponding invoice…
Many sources sheets to one target sheet (master)
I have a need to take information from many source sheets (frequent changes) and replicate that information into a single master sheet to enable other functions. I'm very proficient at using Index/Match - however, the number required and complexity greatly reduces the performance of my sheets. I also have access to data…
Need help with a formula for my asset report
I'd like to know what formula would give me the desired output from data within my asset inventory sheet. I'd like this output to be populated in my report. See example
Countif a dropdown was selected before a certain date
In our project management process, we have a drop down column for an employee to note where a project is in the process, ending with "Completed". I want to do a count for how many of these projects were completed in our last fiscal year. I'm looking for a formula to say "if "completed" was selected before 7/1/2020, then…
Locking cells for dragging so cell for formula stay consistent
I want to lock one cell in a formula so when i drag it will stay on the same cell.
Is there any option for short date that is MMM/YY e.g Sep-21
Currently have sheet that is in short date MMM/YY. We are trying to move this sheet across to smart sheet but an interim period we will still run Excel and copy back over that sheet so consistent format would make thing easy
Dashboards and Minor Analyses
Hi there - I would like a summary sheet to describe the work captured in one of my smartsheets. I think it ought to be a dashboard, but I am having trouble finding the right solution -- I THINK this is because I probably need to do an intermediate step. I would like to have a summary sheet that pulls info from a Smartsheet…
Trying to use a formula in the summary sheet with an AND to look at values from two columns
Hello, I've searched and was not able to find this exactly, and looking over the formula guides I still am not sure how to do this. I am trying to set up a summary field in the sheet summary that looks at the values of two columns and validates both are present to count the field. Here is the best I could do to try to get…
What's the proper way to use the SUBSTITUTE formula for multiple options?
@Paul Newcome I always tag you in my formula questions because you ROCK! I need to map project phases we use in Smartsheet to the the phases we use when we report on our projects. I was able to get the basic function to work using the following formula, but I need to turn this into a string (I'm assuming an OR string) to…

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