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
Formula Issue
Hello! I am trying to reference another sheet column to show how many tours were in 2023. I cannot figure out where I messed up in the formula. Any help would be greatly appreciated! Current formula I am trying: =COUNTIFS({Stanford Hospital Tour Request Range 7})([Tour Date]:[Tour Date], IFERROR(YEAR(@cell), 0) = 2023)
Formula for 2024 returning 0
This discussion was created from comments split from: Last Month Formula?.
COUNTIFS/OR/CONTAINS
Hello all I am trying to create a formula to imitate the following filter login in another sheet i am trying to pull a single figure via a countifs function from 5 different columns if any one of the 5 columns have a yes, that would count as 1 can anyone advise how i can pull this please ? @Paul Newcome @Genevieve P. your…
Formula Assistance
Formula Gurus - I need a formula that can be applied as a column formula in my column named Actual Duration (Days). IF the row is a PARENT row, the formula should return the sum of its children rows. For NON-PARENT rows, the formula should calculate the days between the Act. Start and Act. Finish columns. IF there is an…
Help with WEEKNUMBER formula
Hi, I'm looking for some help with a formula. I need to create a formula in a column named "Period" with the #of the week and month from a system column (modified date). The format I need to use is a combined text with the number of the week and the month, for example "WK 1 Jan", "WK 2 Jan", etc. I tried:…
Card View Details
How can I add additional information to the Card View? I would like to add the column title to the information provided. An example would be the column title of Estimated Completion Date to the date shown in the Card View. Showing only the date without the detail is confusing.
Formula returning "invalid column value", but it looks correct.
I used the AI formula generator in Smartsheets and I'm still getting an invalid column value error. I can't figure out why because there is data in the column. If the IMP/DISC column displays Implementation then I want the value from the Implementation Status Update Date to show. If the IMP/DISC column displays Discovery…
How can I exclude blank cells from from INDEX COLLECT criteria?
Hello, I've got a sheet with over 13,000 rows. My goal is to have end users enter "search criteria" into several cells to narrow the list to a handful of options. The criteria will be Speaker First Name, Speaker Last Name, Specialty, and State. So far, I've been able to pull the information from my source sheet based on…
Need Help with Task Health Formula
Hi - I'm trying to write a task health formula with the following criteria and am hoping someone can help. Here's what I'd like it to calculate: BLUE (NOT STARTED): If the start date is in the future and if the % complete is 0 GREEN (ON TRACK): If today is less than 50% of the task duration and % complete is more than 50%…
Add Summary Value from Sub Tasks
Hi all, I have a project tracker that has been created from a project template then manipulated. The template was pre-programmed to calculate/populate the summary value for the Preparer % Complete column but I would like the Reviewer % Complete column to have a Summary Value as well. Is this possible? Thanks in advance!
Help Article Resources
Trending in Formulas and Functions