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
How to find date having the highest sum when multiple entries per day in a list
I have a running list which collects values submitted by a form. There are multiple users that can submit the form multiple times per day to record a value . I am trying to find a formula which finds the highest summed value for any one day. In this case, the higher the value submitted the worse it is, so I am trying to…
How to only Sum values for unique requests with a specific request type
Hello, I have created a sheet to calculate some data points based off of an archive of requests that get pulled from an Automation when Estimated Completion Date and Actual Completion Date are changed, and I am trying to setup a columns to display the Average Days to Completion for each request type to help with estimates…
Conditional Formatting - Dates in the past
Hi, I want to add a conditional format on a column holding dates that will highlight those dates which are over three years ago. I thought I would be able to pick "is not in the last (days)" and enter 1095, however it only shows "is in the last (days)" For now I have had to add two conditions: "is in the past" AND "is less…
Using a column formula to populate child rows without changing data in parent row of same column
I have a sheet where I am tracking meeting engagements with stakeholders. The Parent Row data is all manually entered and I want the data to autopopulate the children rows of some of the columns (e.g., Sector). I'd like to have a column formula that does this without affecting the data in the parent rows. I have my parent…
Formula with symbols
Hi. I have 10-20 columns that are all using the red, green, or yellow circle symbols for status. Is there a way to make a formula at the far last column that states when all columns are green circles the item is complete??
Grading Test Auomatically
Could someone please provide me some guidance on how to create an SS that, if the form is completed, the SS can grade an exam automatically? I work with General Residents that are going to be future surgeons. They have to complete a 5 hour lecture every week. Our departments faculty is obligated to join them due to having…
How to pull part of a cell to another cell?
I have a list of birthdates, formatted as 01/01/2001. What formula can I use to pull just 01/01 to another cell?
If Then Date
Good afternoon Smartsheet community. I am trying to get an if/then function to output a date in my sheet. I have a few columns I am checking against and feel like I am close but need some help getting it to work properly. Here is my formula: =if(AND([Project Type]@row = "N Type"([3. RWA Acceptance Date (PM/Kayla)]@row =…
IF THEN use for equations/calculations
Does the IF THEN function work for this scenario? IF the number in that cell is negative THEN use this calculation, IF the number is positive, THEN use this other calculation Note: Sorry, due to privacy issues, I cannot share the actual calculations.
COUNT IFS of status with multiple drop down selections
Hello- I need to calculate the total # of times a status appears, and it is also dependent on other criteria being met. The current formula I am using will only be counted if that status is in the only status in the cell. =COUNTIFS({Weekly Status Product Development Range 1}, "OFF TRACK", {Weekly Status Product Development…
Help Article Resources
Trending in Formulas and Functions