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.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

I need some help with a calculation. I am hoping you can help.
I need to have a column calculate the status of a project based on where today stands compared to its % complete and where we are between the projected start and finish date. As an example. This is what is entered manually. Start End % complete Project status 01/07/24 22/11/24 92% In Progress - On Track Today is Oct 18th…
How to Get a Balance Column to Show the Balance Remaining in Each Row
I am trying to create a budget sheet which shows the remaining balance for each line. Here are my columns: Order: This column has the following formula =MATCH([Row ID]@row, [Row ID]:[Row ID], 0) to allow me to move around items to better fit the budget balance for each period. Row ID: This is the auto-numbered smartsheet…
=COUNTIFS Metrics across 2 different sheets
Hi All, I have a metrics sheet where 4 of the 5 listed items reference 1 sheet and the last 1 references another sheet. I keep getting #UNPARSEABLE error for the 5th item. Below is my formula if anyone can help me figure out what is wrong that would be great! =COUNTIFS({Sheet - Continuous Improvement Sheet}{Project…
Check Box Across Sheets
Hi, I have two sheets, one is an intake sheet and the other is a metrics sheet. Metrics Sheet Plan has an OR(ISDATE( Formula to raise flag is a date is entered Agents has an IFERROR(INDEX(DISTINCT formula to capture the agents from the Intake Sheet Intake Sheet I want to add a Formula that can Raise a Flag under the PLAN…
Help with Long IF,AND,OR formula
Hi, Needing some help with the below formula. Everything is working correctly but the last IF/AND/OR statement and can't figure out what I'm missing. Any help is greatly apricated. =IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = true, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row =…
Summary Sheet Formula and Milestone / Key Task Gantt
Hello community, I am new to using the smartsheet so hoping you can help me with the below. How can I update this fomula that I am planning to use in my Summary Sheet so that it only includes count of tasks that has a start date of in the future. I want to exclude those from my count. I consolidated 3 projects into one…
Need help with a formula
I'm trying to write a formula to capture the times a data point occurs in two different sheets. I've written a formula =COUNTIFS({range 1}, "Early", {range 2}, "Early"). the formula is not capturing correctly. Anyone know what I'm doing wrong
Index Match Help
I can't seem to get this Index Match to pull all information its just pulling certain cells and I don't know why. I've tried VLOOKUP with the same results as well. Basically I have a sheet, Business Tracker, that tracks the names of Segments, the different levels of leaders, the FTE and call volumes numbers from their call…
Attachment Auto Email
I need an auto flow that can email an attachment I was reading posts from 2020 that said it could be done but those options seem to be out of date. Can I automatically send attachments automatically via automated flow?
Return most recent date of co-located sites
I am running a yearly list of sites that are being inspected and need to return the most recent inspection date for those sites that are co-located (same address, different site IDs) I have tried using the index countifs and get Incorrect data types even though all the date columns and the co-located visit helper column…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Can anyone tell me what's wrong with my formula?
I'm trying to set up a project plan that has color indicators for the timeline: RED=past due, Yellow=due in the next 5 days, Green=due in the next 14 days, Blue=due later. =IF([Due Date]2 < TODAY(), "Red", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 < TODAY(+5))), "Yellow", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 <…
Help with a #UNPARSEABLE error
I want to reference the values in a column from another sheet (2025 IOE Procedure Assessments Equipment). And if any of them match any cell from the Equipment column from the sheet I'm working in then, I want the Audit on Equipment Completed column to return a "Completed" value. This is my formula. What is wrong with it?…
I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags