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
IF/Index/Match
It's Monday and I can't seem to get this one to work. If a value populates in a cell in a specific column (this is a formula column) Every row that contains this data (All the columns) it would fill in the data that's listed in the formula column.
IF/OR Formula
Hello - I am trying to make a formula work but having issues. I have a more significant formula that is correct but when I add to it, I mess it up and can't figure out what I'm not doing. I can make each formula work on its own but having trouble merging them. The following formula works. I need all of it but I also need…
sumifs
Hello, I am trying to sum project hours by project per month and seem to be missing something. I am trying to use: =SUMIFS(Hours:Hours, Project:Project, "HGI Condado", Month:Month, "January") But this formula yields "invalid data type". Not sure what I did wrong. nay help would be great!
If match formula
Hello! I'm trying to catch if there are any discrepancies between model homes on our manual entry vs the systems data. Model homes should be based on whether ADA is required or not. I've already created a helper column that tells me if model homes don't match but I need to add the "ADA Required?" column to my formula and I…
Can I turn text into a contact?
I'm using Data Uploader to bring in data from another database, and task owners are brought into a sheet as [First Last] in text. I'd love to turn that into a contact. Does anyone know of a formula I could use? Any other ideas?
Calculating a Total Occurring within a Specific Month (SUMIF)
Hello, I am working off the provided personal car mileage tracker to create a monthly total for an employee. I am creating a sheet summary formula. My formula isn't giving me an error but it isn't calculating either! I've tried it with and without the parent/child indentation and same result. I want to calculate the total…
If Column A contains specific text and Column B contains specific text, then Column C is text
Hello, I am not sure how to figure this out. I have tried IF, INDEX, CONTAINS with no luck. What I am trying to do is set up on Impact/Effort Matrix with a formula that looks at the text in Column "Effort" and Column "Impact" then returns certain text in Column C. For example: If Effort is "low" and Impact is "low" then…
COUNTM and/or COUNTIFS formula and checkboxes
I have a project plan that tracks root causes of variances for milestone tasks. The variance root cause is a multi-select drop down list. Milestone tasks are identified using a checkbox. I am trying to count the total number of root causes for all milestone tasks. I do not want to include root causes that may been…
Formula
I am getting unparseable on this formula and I am stumped! =([NB MONTHLY 2023]@row - [NB MONTHLY 2022]@row) / [NB MONTHLY 2023]@ROW
Why This SUMIFS Formula Doesn't Work?
I'm trying to identify how much Overall Projected Volume will Bill in the Year 2023 for Joe Smith. Not sure why this formula doesn't work? =SUMIFS([Billing Year]:[Billing Year], "2023", [Overall Projected Volume]:[Overall Projected Volume], [Opportunity Owner]:[Opportunity Owner], "Joe Smith")
Help Article Resources
Trending in Formulas and Functions
