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.

I want the total count from 2 sheets from a column with multiple leads
When I created the first formula it worked, when I add the second one linked to another sheet I get the nested criteria error. Even when I remove the extra end parenthesis still an error. Separately these both work together it doesn't work
Setting checkbox as true based on conditions of multiple columns
Hi! I am trying to set a formula that will check a checkbox based on conditions of multiple columns. This is the formula that I am trying to use: =IF((COUNTIFS([PMO: Contract requirements review]24:[PMO: Is customer source inspection required?]24, "complete")+countifs([PMO: Contract requirements review]24:[PMO: Is customer…
Formula Creation & Random Changes
Hi All, I'm building a reference Sheet off of a 'Master' Smartsheet in order to create a Dashboard for some KPI type tracking. I'm pretty OK with formulas, the main ones I'm using here are simple =SUMIFS() and -COUNTIFS() Example: =SUMIFS({TYS Master Data - From SFDC Range 1}, {TYS Master Data - From SFDC Range 3},…
Conditions
How do I stop an email from being generated from a condition in one cell that is sent out after it passes a certain day? I want the emails to stop when a condition is met in a different cell.
Help With Using LARGE in a Date Modified Column
Does anyone have experience with using LARGE in a formula to return results with latest Date Modified? I am needing to return a string that ends in the date & time a contract is marked as complete. In this instance I am looking to return a string for the 5th newest contract completion date (I am compiling the top 5 if that…
How many file size can be uploaded per row?
Hi good day! Im just wondering, if how many files can be uploaded in a row, or how many KB per row?
Percentage Question
Hi, I am sure this is simple, but everything I have tried isn't working. I am working on a time allocation sheet and I need to work out how much of the day is allocated to a certain project: "Daily Hours" Column - will always be 9:00 (hh:mm) "Time Allocation" Column - our PM's will add into a column how much time allocated…
index and Match that Sums everything
i have right now =INDEX({Project Tracker - By Work Package Range 1}, MATCH([SYSTEM/CABLE]@row, {Project Tracker - By Work Package Range 2}, 0)) this works great but it only comes back with the First number it finds. i need it to Come back with a Sum or Total of all the Numbers it finds. Sheet i want the info on. working…
Calculating % of completion based on start & End dates
I'm looking for a formula that calculates the % of completion based on start and end dates
Formula to determine next available date
Im trying to determine the next available date based on end date, Job status as active and the event type contains install. This formula returns a date =MAX(COLLECT({End Date}, {Job Status}, "Active")) Ive tried adding the contains install but it doesnt return a date =MAX(COLLECT({End Date}, {Job Status}, "Active", {Event…

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

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags