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.

Report Not Updating
I have several reports setup to filter a sheet by status and up until today everything worked fine. Now, when the status changes, the report doesn't get updated and I don't understand why. For example one of the reports filters for a status of "Design" and when I perform the necessary steps to move it out of the "Design"…
Sumifs with Date Range
Hi there! I'm using Smartsheet to keep track of timelines and allocated ressources called FTEs across multiple projects. I'm trying to figure otut a way using the SUMIFS formula to sum up the usage of FTEs across all projects per month. Currently, I'm using =SUMIFS(FTE:FTE; Projekt:Projekt; "Project A"; Start:Start;…
Formulas For Metrics
Good afternoon, Looking for some help on setting up formulas to capture the following metrics per attached. Any help would be greatly appreciated. Thank you !
Modify scale on an axis of a graph
Good Day t´s possisble modify scale in an axis of a graph exist? for example, I have a graph, in the vertical axis the scale it´s 0.5 to 0.5, but i want that scale will be 1 to 1, it´s possible? regards
Formula Sumif Range w. Web Form
I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, Task5, Hours2:Hours4) New Webform entry is line 5, Formula will not automatically capture that added line. Please help.…
Issue with Nested IF Formula
I am having trouble getting my nested if formula to work. I have the following formula: =IF([DCO Status]@row = "Implemented", "Blue", IF(AND([Days Open]@row > 46, [Days Open]@row < 100), "Yellow", IF([Days Open]@row >= 100, "Red", IF([Days Open]@row <= 45, "Green", "")))) It is working for all the cells except the blank…
Count How Many between Percentages
Hello, I have a list of documents that are being reviewed. People have to indicate what percentage they have completed. So if someone could be 20% done, someone else could be 30%, then another is 50%, etc. I want to be able to count how many are 0% done, 1 - 30%, 31 - 50%, 51 - 75%, 76 - 99%, and 100%. Is there a way to do…
Add row data to a separate sheet ONLY if a box is checked
Ok. After 1.5 hours of trying to figure this out myself, I am reaching out to the experts. I have multiple Smartsheet Forms feeding into one Master Data Sheet. Each row of incoming data is then assessed for approval based on certain cell criteria, and if approved I check a box in the "Approval" column (image belwo). Based…
Calculate Points of Symbols?
I have three symbol fields Priority (uses Priority High, Low), Impact (uses Measure One, Two, Three, Four, Five), and Size (uses Measure One, Two, Three, Four, Five) I would like to roll up points in a column for this. Impact and Size would convert to integers, High Priority would add +5, Low Priority -2. Can I do this all…
Percentage Complete Column (Breaks)
Greetings, I've discovered that the % Complete Column in a few of my sheets has broken, is incomplete at calculating the true completion percentage for a project. I suspect this might have happened somewhere along the line of adding/removing rows. Is there any way to see/edit the formula to ensure it is counting all rows…

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

Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags