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
ROLLING 30 DAY AVERAGE SHEET SUMMARY
Hello, I'm looking to build a formula in the Sheet Summary that will provide a rolling 30 day average from the PROD values. (attached is a data subset) Feels like this should be fairly basic, but am struggling to find the solution. Anyone's help would be appreciated.
IF/AND/OR Assistance Needed!
I'm trying to pull up the number of product sales by Region. Region is a multi select column. t works perfect when there's only once instance of MEA - SA or MEA - ME but there's one instance where I have both MEA - ME and MEA - SA in the same cell. I'm struggling on how to combine all three options together. Essentially if…
COUNTIFS ASSISTANCE
I want to count the number of "training" for Elter Wilson on 3/6/24. What would the COUNTIF statement look like? Also what if I had a 4th criteria of Pass? I am creating a results report so need to reference this other sheet.
Edit cells with column formula
Is there a way to edit the cells where a column formula is used? I am trying to link information from 1 database to another via a INDEX MATCH formula, so we don't have to re-write info 2 times. However, the databases does not contain the same projects (we link info based on project number). See below - Project name is…
I would like Smartsheet to Return Number of a Pay Period based on Current Date
Hi everyone. Thank you in advance for trying to help me. Here is what I have. Based on Today's Data aka Current Date.. I would like to my Pay Roll Information sheet and return the Number of PP. Based on this current date, It should return 6. This sheet contains my Pay Period Information I am trying to get it to return to…
Convert a table [Name]x[Technologie] into a table [Name]x[Level]
Hello, I'm having trouble converting a table like this one: into a table like this one (values within both examples are illustrative and aren't meant to match): I need to build a database with only 4 columns (level 1 to 4) inside which I must store every technology that the person described in [First and last name]@row…
Date of task completion "On Time" or "Late"
I am trying to create a formula that will simply determine if a project is approved "On Time" or "Late", or if the "Plan Due Date [45 Days]" cell is blank (auto-populates based on a submission date cell, not populate the cell at all. I have reviewed several other discussion posts and best answers but I cannot get any of…
Owner rights and formulas
Hi, I'm the owner of multiple sheets. I'm having issues changing the formulas that have been applied to the entire column. It is telling me that only the owner of the sheet can make changes. Since I am the owner, how do I go about correcting this issue.
How to use multiple Matches in an Index + Match formula.
Hi community, Trying to use multiple conditions (matches) to pull data from a table (range). Currently, the Index + Match formula combination is only able to use ONE match condition. Can you use 2 or more matches with Index formula?
Formula help for marking a cell as blank
Hello, I'd appreciate if someone can check my work on this health formula. It's successful when tested separately and combined, though the only one proving to cause an issue is when I add in the final line (which works separately) . Thanks in advance! Logic: Add a red circle to this cell if due date is in the past and the…
Help Article Resources
Trending in Formulas and Functions