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.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Subtract minutes from Hours
Greetings, I'm trying to subtract minutes from a set number of hours and display the amount of time left in HH:SS. For Example: There are 10 hours available for testing but totally the environment came up 35 minutes late. I know it is something simple but I'm missing it.
Create an automation to move dynamically copy a row to a new sheet
Hi, So I am currently working on the system where I can dynamically copy aggregation of some data from master database to another sheet. We set up a master database on project level to collect data from form submission, this sheet contains all data from all projects for every quarter. The projects delivered by two delivery…
Quick Formula Help
Hi Community, I'm working with a colleague to create a column formula with multiple IF conditions. Just struggling to get our initial chain going before adding in others. What we need: -We have a column entitled "Submission Type" that contains a dropdown list of different submissions. Each submission has an estimated…
Status is <> Complete and the Need by date is behind todays date then should change symbol to RED
IF the status is not COMPLETE and the need by date is behind todays date would want to have the color be Red. If it is current or in the future of todays date would be Green. Been striking out... here was my latest try =IF(Status@row <> "Complete", "Red", "Green"), IF(AND([Need by Date]@row<=TODAY()), "Red", "Green")))
Raise Flag Formula
Hi, I am struggling to get a formula to show: When the dropdown 'Pending' is selected a red flag is raised? Thanks for your help in advance!😀
trying to formulate a calculation
COUNTIF({Range}, AND(>-365, <0)) so i have a column for # days to due date and based on that, i want to count the number of tasks that are due for the past 12 months and above is the formula that i created but im getting invalid operations. please advice further. i did include the range.
Error when using =Month formula if no date in a column
I am using the following formula: =MONTH([Due Date]@row) If my "Due Date" cell is empty I get the following error #INVALID DATA TYP I may not always know the Due Date until the project moves on for some task. I am looking for away to modify the formula to ignore a blank Due Date and give me nothing or return a "0" Any help…
True/False VLOOKUP if cell on one sheet appears anywhere in column on another sheet
I'm trying to created a VLOOKUP formula the checks whether a cell value that lives on the same sheet as the formula can be found in anywhere in a column on a corresponding sheet. The formula should return a True/False value, or check a checkbox - whichever is simplest. I'm fairly certain the cell value should appear as…
Voting using Symbols Formula
I want to collect "votes" from multiple voters (columns Voter 1, Voter 2, Voter 3, Voter 4, Voter 5, Voter 6) using RYG Balls in a sheet. Each row represents an item that is received through a form that must be voted on. I have a "Tally Vote" column that I want to use as a summary of sorts to reflect status at a glance in…
Formula to turn the background red
Hi, I have been struggling with this one. I want background in the column "B", column "C" and Column "D" to turn Red Automatically if the date in the column "A" was more than a week ago. Any help will be appreciated :)

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

COUNTIF with AND
I've written the statement but am getting a #INCORRECT ARGUMENT SET error. I'm new to SS, any help is appreciated. =COUNTIF(AND([Opportunity Risk Path]:[Opportunity Risk Path], [Module Approval Status]:[Module Approval Status], ="Conventional", "Not Started"))
IF CONTAINS Formula to return different text values in second column
Hi! I am looking for some help in creating a formula where if a certain word is found in one column, another word is returned in a second column. For example if "Head", "Nasal", or "Spine" is contained in the Procedure column, "Neuro" is returned in the Clinical Specialty column. I've tried different variations of this and…
I need to result the column's name when using a JOIN(COLLECT) or INDEX(MATCH) formula
Previously, Row 1 of my smartsheet contained the column's name. This way, I could write a JOIN(COLLECT) formula to return the column's name if certain conditions were met throughout the sheet for that row. That worked until we applied column formulas to some of the rows. Now Row 1 can't be the column's name because of the…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags