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
Losing hair from index:match
Hey All. I've read through every post I can find on index match but my formula is still coming up unparsable no matter what I try. I am trying to reference columns across 2 sheets. I've created references in the end sheet under Manage References. Here's the latest version of my formula and then a list of things I've tried…
Overriding Due Date when a box is checked
I currently have a sheet with several dependent tasks. Right now I have predecessors set but I am trying to find a way to trigger the next task/row to start once the row above is marked as complete. I was thinking that I could possibly have today's date entered in the task completed date column so I can use the start to…
return the value if the criteria meet 45 days and the name of the client is not empty.
This discussion was created from comments split from: Count If and Not blank.
Counting Formula Help
Hi, I am looking for a formula that counts that instances that a particular department was listed. In my scenario, Person 1 & Person 2 belong to the same department. Current formula I am using is Attendances by Person 1 + Attendances by Person 2 which gives me a result of 6 however, since they are from the same department,…
Need Assistance in Formulae
I have 2 tables as below, I need assistance in populating column Notification Table 1 Table 2 : Ask : Based on the Title of the task, I want to pull all the users associated with it. I was able to perform for one title value with Join and Collect. I need assistance modifying the logic so that if the title contains 2…
Create formula in summary to calcuate based on date
Hi, I am trying to use formula on my sheet summary to provide me with the total documents received based on if the date received is before May 1, 2024, of this year. Anyone can help me with that?
Countifs with OR
I feel like I almost have it: =COUNTIFS({MMES},"0", @cell), {Disease Extent}, OR(CONTAINS("Proctitis", @cell), (CONTAINS("No disease activity", @cell) Count if the column titled MMES has "0" and the column titled Disease Extent has "Proctitis" OR has "No disease activity" HELP!
Please help with combined SUMIF, INDEX, and MATCH formula
I'm trying to sum the $ amount of quotes submitted every week of the year. I have my Quotes and Sales Master Log 2024 sheet which I'm referencing and Weekly Totals 2024 sheet to calculate data into. I have the #UNPARSEABLE error right now and I tried few variations of the same formula but haven't been able to figure it out…
automation for moving specific columns
To move specific column values from my source sheet to another sheet, I can't use a lookup formula because the entries in the source sheet are constantly changing and not permanently established. In my second sheet, a new row should always be added with values from certain columns from the source sheet. The row should be…
Applying / Syncing Information from One to Another Using a Lookup or Join
All, First time posting here. I have two separate smartsheets (Smartsheet A and B). SmartSheet A contains our inventory. Smartsheet B consists of our Customer's Data such as which state they are in and GPS details. My personnel don't have access to SmartSheet A. They only have access to Smartsheet B. When my personnel…
Help Article Resources
Trending in Formulas and Functions