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.

Is there a way to limit how many cards can be dragged into a single lane?
I have a kanban board and want to limit the number of "cards" that can be in the "WIP" lane. I also have another file where I have ABCD ranked projects, and want to limit how many can be an "A" project. is there a way to automatically achieve this? I know I can see the sum of the number on top of the lane, but is there a…
Capture the date in the cell when it is populated
If I would like to capture the date of a cell when an update is made, is there any way to do so without using 3rd party integration? Cannot use modified date by system as there will be more updating of data in that row. I understand that we can always put another date column to manually input the date, but just trying to…
Subtracting two cells and getting Invalid Operation error
Good day, I am struggling with a formula that keeps giving me an Invalid Operation error. Am I doing something wrong? Regards M
Can I extract the name of a column and use it in a formula?
I have a table set up with data organized by quarter (3W20, 4Q20, 1Q21, etc), and am using the quarters as the names of the columns. I have formulas in the columns that display data for that quarter, but I've had to manually type in things like "3Q20" in my SUMIFS formula for one of the criteria. Is there a way to pull out…
Help with Index Match bringing back Children row data based on Parent Row Match
How do I get Index/Match to do the following: Look at Source sheet column for a Match in a Parent row and if there is a match, pull in two date columns for all the CHILDREN. This formula is pulling in dates but only for the first PARENT/CHILD section. It's not checking the MATCH on the Parent Asset #. =INDEX(COLLECT({Test…
¿Cómo encuentro el valor de auditoria diario?
Esta es mi formula: =COUNTIFS({LAYOUT CHECK FOR DAL Range 5}, "DAL 1", {LAYOUT CHECK FOR DAL Range 6}, "Si", {LAYOUT CHECK FOR DAL Rango 2}, "14/08/20") Cuenta si en columna 5 encuentra "DAL 1" Cuenta si en columna 6 encuentra "Si" Pero como hago para que busque siempre en fecha actual, es decir con alguna función today
Sumifs Question
I have this formula with sumifs and I am trying to add "and is not " =COUNTIFS({Marketing WIP - Bone Pile Range 1}, "christina", {Marketing WIP - Bone Pile Range 2}, "PROPOSAL") + COUNTIFS({Marketing WIP - Bone Pile Range 1}, "christina", {Marketing WIP - Bone Pile Range 2}, "QUALIFICATIONS") I want to add and range is not…
Complex IF statement between two sheets with a checkbox
Hi, I am having trouble figuring out how to create a formula. I have one sheet "Step 1-Validations-CBRE" that will contain a full list of vehicle IDs and another sheet "Fleet Inspections" that will contain the submissions for vehicle inspections. Ultimately, I am trying to determine which vehicles have had inspections…
Help to convert DATE & TIME to month format
HI! The reporting tool I extract the data from provides the date as 10/30/2019 04:58 pm and I would like to know how to convert this to a Month format. Help please?
Display Modified Date/Time in 1 Consistent Time Zone
Is there a way to pull the UTC or server-stored Modified Date and NOT show my time zone's display? My ultimate goal: we need to display the last modified date AND time consistently regardless of the user's time zone.

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