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.
Discussion List
COUNTIFS incorrect argument set
Hello, I am looking to gather metrics from a sheet of QC submissions. I have a very limited understanding of formulas but have managed to put together something that works through looking at examples on here and the tutorials. I have had success with the following formula counting the number of submissions of a certain…
Formula needed to return value
Hello! We are a small nonprofit and are trying to build a Smartsheet that allows volunteers to sign in, choose which outreach (activity) they do, and then based on their outreach choice, the formula would automatically assign a number of hours for that outreach (so that we can track volunteers number of hours worked.) I am…
Change value of child based on parent
In this sheet I'm monitoring the inventory of raw materials. Currently, each child row compares available stock to low stock amount and returns OK or "low". However, the parent includes the total of all batches of the raw material, so that even if one batch is low, the quantity of the raw material might be sufficient. So,…
Can I automate a cell to change color?
I have a column called "Due Date" that I want to turn red when 4 weeks from the due date have past. Is there way to change either the cell color or text color?
Formula for populating a due date
I am trying to set a formula to automatically populate the due date using workdays only and excluding holidays. I have a beginning date and would like the end date to be the formulated due date. I am stumped on this formula! Anyone suggestions are appreciated.
NETWORKDAYS formula with future dates
Hi, I am trying to work up a NETWORKDAYS formula to calculate "Days Active", either calculating between the Approved Launch Date and Close Date, or Approved Launch Date and TODAY(), if the Close Date cell is blank(basically, stop counting the days once the close date is entered). I managed to use the following:…
Date range and duplicate values
Hi, We are trying to use Smartsheet to manage our engineers. At the moment, an engineer can only be on one project at a time. Is there a way to search a Start and Finish column and see if an engineer's initials appear twice anywhere within that Start and Finish range? I've attached a screenshot of how it looks currently:…
Formula Help Subtracting a Day
I have a networkdays formula that i need to have subtract 1 day because it is counting same day efforts as 1 day and i need it to count it as 0 days. How should i update my formula? =IFERROR(NETWORKDAYS([Actual Start Date]@row, [Sub-Task Completion Date]@row), "")
Using entire columns to create dashboards in lieu of cells
I am tryin to create a dashboard that tracks a trend over time (weeks). It is pulling from a sheet where we document production week to week. I'd like to create a dashboard that will pull from the entire columns so that when I add future data it will automatically pull into the dashboard. So far it seems that I have to…
Formula help
I have 2 smartsheets 1)Schedule and 2)current week schedule both have a column for colleagues and columns with the current date (not a date field - needed to be text since the data in the actual cell is text) I have added a helper row and added the text date there as well What I need to happen is for the information in the…
Help Article Resources
Trending in Formulas and Functions
COUNTIFS formula for any future date?
Hi all, I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date. I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working. Any advice would be appreciated! Thank you.
Sheet Summary Field - Count Value from Dropdown
What's wrong with this Formula? Getting an Invalid Ref
I am trying to get a unit count between a date range.
I am trying to get a unit count between a date range. I have two difference columns from one sheet and two difference columns on my main sheet I am referencing. I keep getting unparseable. Is there a way to to get the number I want with using the countifs formula? Or should I be using a different formula? This is the…