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.

Stopping alerts once completed
Hi all, I'm new to setting up alerts and would appreciate some guidance. I have a list of ~500 people. I have their first and last names and email addresses. They need to add an ID#, click a dropdown choice and enter a date. That's all. I've set up an alert to send an alert daily, but how do I stop the alerts from being…
SUM a column if another contains value
I'm trying to figure out how to count the sum of a column if another column contains a specific keyword. I have a list of vendor names that have been paid, how can I count the balance by vendor? Thanks!
Multiple Email address using SmartSheet form
Hello Friends, Is it possible to take multiple email address from user using SmartSheet form under same column (Type: Contact List) Example: I have a form with fieldname "Cc email address" where we need user to input multiple email address as cc email address. Accordingly I have setup a automation workflow to send email…
Need help to write a formula to count projects within a date range for the specific project manager
Happy New Year. I am trying to write a formula that allows me to count the # of projects with in a date range i.e. greater than 4/1/20 and less than Today's date for a specified project manager
Number of Tasks
Hi, I have a sheet that I am trying to get the number of total tasks to match up with the number of completed tasks. I have two columns "Is Task" which is a checkbox column that i use the formula =IF(COUNT(CHILDREN(Tasks@row)) = 0, 1, 0). This checks only the tasks and not the parent rows. "Status" in which I use the…
Date is within 7 days of today calculation
I have a date field (field name = Reim due date) that is a calculation based on another date field. I am trying to create a countif summary sheet field that says 'count if the Reim due date is within the next 7 days.' Formula below is coming back unparseable. =COUNTIF([Reim due date]:[Reim Due date]),>TODAY(+7))
Is there a way to set up a statement based on whether or not a cell is a "Parent?"
If X cell is a "Parent" cell, I want the data outcome in Y cell to be 1. If X cell is not a "Parent" cell, I want the data outcome in Y cell to be 0.
Help with AverageIF/Collect formula
Hey there! Long time listener, first time caller. Im looking at needing some assistance with multiple criteria formula to pull in average costs for construction projects based on PROJECT TYPE and PROJECT STATUS. My desired end result is to view the AVG cost on a project type basis for all projects that fall under green,…
IF(count) function
I have a smartsheet that is performing a lookup on another smartsheet to see if a value exists. It doesn't seem to be working though because it always comes back as false. Any ideas what I might have done wrong? Smartsheet 1: =IF(CONTAINS([Cost Center]@row, {RML Pulse Cost Accounting Range 1}), "Green", "Red") [Cost…
SUMIFS for prior month
I've been trying to figure this one out for a while and cannot get it to work. We want to have a count of how many RFPs meet criteria for the prior month (without having to filter on a report every time). Is this possible? Here's what I have for the simplest one, but it is not giving me the correct number:…

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

NEED TO ADD DAYS TO THIS FORMULA IF ANOTHER CELL HAS SPECIFIC ITEMS OF A DROP DOWN.
I have this formula that works for this cell when information is missing from reference cell A. However now we want to be able to add additional days if reference cell B has specific items checked in a dropdown. I just can't seem to get it to work. Any suggestions. =IF(ISBLANK([ ENGINEER (tentative start date)]@row), "",…
Check a Box if Between Dates on Another Sheet
Hey all, I am trying to build a formula to check off a box on my sheet if at least one date is found between two dates on a separate sheet. I've tried a million variations but here's what I have so far, thinking I was overcomplicating things =COUNTIFS({Approve Date}, >=[Week Starts]@row, {Approve Date}, <=[Week Ends]@row,…
How to Automatically Checkmark a Column for entries that are created within a time-based timeframe
I'm trying to write a formula that will automatically place a checkmark in a checkbox column titled "Today Entry" whenever entries meet the "Created" column criteria of being submitted after 1100 AM the day prior and 0800 AM today on a rolling basis: I've been trying to use the below column, but honestly I have no idea. I…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags