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.

SUMIF Not Equal To Formula
I am using this formula to Sum all values except for the ones assigned to "External"..It still adds these hours. What did I miss? =SUMIF([Resource Type]:[Resource Type], "<> *External*", Hours:Hours)
Expired Date code
So i recently create a new Cell called " Expired Date" what I'm trying to do in this cell is to show when a date has been expired , based on the Promised Date, but i found that if i left mi code just like this, But =IF([Promised Date]4 > TODAY(0), "Expired date", "-" i don't have a restriction. And i try this code, but i…
Date and month, linking cells
Hi there I'm linking cells from numerous sheets to one specific. Most of the cells are containing dates. When linking, I have realised that month and date have switched places. Not all dates/cells, but in some cases. See below example. Original work sheet: 03/06/19 Linking work sheet: 06/03/19 I've double checked the…
Index, Match, Parent
I'm trying to dynamically change a cell's value depending if a checkbox is checked or not. Directors of a project would like to know what stage a project is at and if that stage is on target or not. Where I'm running into trouble is the directors only care about the Parent Task and not the child tasks. This is what I have…
SUM Count of children Checkboxes
Hello, I am trying to add the children count of several columns but I just have a 0 as a result of a simple =Sum() formula.
Compound IF Statement
I am trying to determine a Classification when a Weighted Score is between two values. =IF(AND([Weighted Score]15 > 31, [Weighted Score]15 < 61, "B")) In this formula, I want to return a "B" when a Weighted Value is between 31 and 61. But I get Incorrect Argument. Can someone please help me. Dee
Automated Workflows Not Quite There
Hi I wanted to use automation to help update fields in a sheet and that does not work. If I update a field for example When field "With" changes to "Cierr" change the complete column to "Star" This does not work. I have to create a calculation in the cell to reference this. It would be much easier to add automation for the…
Date Dependency
Hi, Our ERP system exports tasks and the materials needed for those tasks with the same task ID number. We schedule based on the actual task and predicted duration. Is there a way to automatically assign the same start date to the materials needed for the tasks based on the scheduling of the actual task? Screenshot…
Nested COUNTIF formula
Hi! I am hoping someone can help me solve this formula. What I am trying to do is keep a running total of hours of vacation used. For example, If Joe wants to take an 8 hour vacation he will go to the dates and type in "V8" (Vacation, 8 hours) or 4 hours would be "V4".ETC. When this is entered I want those hours to be…
Most Recent Date
Hi everyone... I've been struggling with how to do the right formula here and would love if anyone could help. I have a form which people are to fill out twice a month to do a temperature check on their progress. The data will have the date, name, etc., then their "mood" (a dropdown list), and each entry will be a separate…

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