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
Sheet summary formula to SUM a column where cells are formulas
In my sheet summary, I am trying to sum/total a column where the cell values are populated as a result of a formula. I can't seem to get a value. The formula for the cells I am trying to sum is this: =IF([Item Type]15 = "Stand Alone", "150", IF([Item Type]15 = "Unfolding", "450")) It is referring to one other column. I…
Need unique data line
Hi team, I have multiple duplicate date rows in my tracker but i need a single line for each date.. how's possible ? need single line for like below 27-oct-2020 : CTMC-RC2/2015/WPTA/201400772K 13-feb-2021 : CTMC-RC2/BLP/2017/WPTA/201400772K
How to ignore blank cells when stringing cell values together
Hi everyone! Hoping someone can help me out. I have created a Smartsheet form that someone can fill out to create a custom URL. On the backend of the Smartsheet, I have a formula set up to string all the values together and add delimiters into a url string. It works great, with one exception. All of the form fields are…
If month is January set to Q1
I would like to set up a formula that is based on a dropdown of the months. Q1 would be January to March. I have been looking at using the month's formula but realized that it works off of dates, not a month dropdown. Is there a formula that I can use to update the quarter based on the month from the drop-down?
Smartsheet alert 3 days before the first Thursday of the month
Is there a way w/o having to create a date column and just list the first Thursday of each month manually to send an alert 3 days before. I know I can send one for each 1st Thursday but I need the alert to go off a few days before. Thank you
has anyone had issues with workflows becoming randomly invalid
Below is the automated response I have been getting on a couple of project that I manage. Any help or suggestions on how to correct would be greatly appreciated. Best, Anthony D'Ambrosio PMP-16-0244 POR-18-CH&HKR-AMZ Portfolio Workflow Delivery Alert The following people included in the Alert workflow for "PMP-16-0244…
Why is an error message invalid data type generated for this formula (Please provide proper syntax)
Why is an error message invalid data type generated for this formula (Please provide proper syntax)? =IF(AND([Start Date]@row <= TODAY(), Status@row = "Not Started", "Red"), IF(AND([End Date]@row <= TODAY(), Status@row = "Complete"), "Red", "Green"))
Formula for Status
Hello, I am trying to create a formula to automate the 'status' row in my project grid in SmartSheet. Here is what I am looking for: Actual start date = Blank, show "Not Started" If Actual Start Date = is a date and Actual end date = Blank, show "In Progress" If Actual start date = blank and projected start date > today OR…
COUNTIF vs COUNTIF HAS
I have the simple COUNTIF formula in a roll up sheet but am struggling with the formula picking up a single entry from a multiple dropdown selection: The simple count if formula that is working is: =COUNTIF({Sprint Tracker Range 5}, "Subject") The more complex COUNTIF with HAS I have created is that is not working is:…
Conditional Formatting
I have never had this issue but currently I have conditional formatting set to make a cell 'red' if the due date is in the past. The date is calculated based on a formula from other cells but this is a date column. The conditional formatting will not work. I have several dates in the past and none are following the…
Help Article Resources
Trending in Formulas and Functions