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.

Splitting data across multiple rows based on dates
Hi Everyone! As a Project Manager I would like to report total scheduled hours per week for an individual team member. Does anyone know how I can go about doing that in SmartSheet in a way that will update if the project plan is updated? I would prefer if this was performed in a separate sheet instead of the project…
Trying to Autofill filed with Text based on data submitted by form.
I am currently working on a sheet where pending on the multiple options they chose it field A it will Mark other fields as requested. Then once the resource is assigned we can mark as assigned. How do I do this in Smartsheet. I have tried some things but not sure what I am missing. Any help is appreciated.
Metadata sheet pulling data from 40 project plans into 1 dashboard?
I am working with sheets, already created. There's 1 project plan and several sheet i.e. a RAID log and a Decision log that go along with each project. Then there is a metadata sheet (1 per project) that pulls info from the project plan and calculates it and then it gets displayed in a dashboard. The lastest ask is a…
"Sprint#" dropdown single-selector that inserts Start Date & End Date
Seeking help on crafting a sprint calendar widget. I've set up a dropdown selector for "Sprint" - a single-select text cell with name: "Sprint 112" or "manual entry". I would love it if I could have the the selection in this cell fill the start and end date cells (or not, if "manual entry" is selected). I'm using a…
Project Template
Hello! I am utilizing the Project Template to create a Comm Flow plan. I am getting bit hung up on the predecessors and dependencies. I need the calendar to highlight 3 things. Is it possible for the sheet to highlight 3 separate dates on the calendar without being a bar? AND is there any way to make those 3 separate dates…
How do I account for a specific status in a formula calculating expiration status?
I am using the following formula to count the number of contracts that are expired =COUNTIF([Contract Expiration Date]:[Contract Expiration Date], <TODAY()) I want to exclude any contracts that have "Archived" (Value) as the "Current Status" (Column) from this count.
COUNTIF Date Next Month
So, I'm trying to create a sheet summary formula that will count the number of milestones in my project schedule that is due next month. Because I have a section in my project schedule for milestones that is linked to various tasks throughout the project schedule I'm able to use the CHILDREN() function to limit the range.…
Is there an easy way to search two cells to see if they match?
I've got two columns, ones a Contacts column with a drop down select, the other is a system column that is automatic and puts in the user email address. Both populate via a form. Is there a simple way to search both these columns and check if there's a match and display something like MATCH or NO MATCH? Thanks.
Automation based on date
Hi, I'm looking for a formula that can be used to automate sending out a reminder based on a certain date for every X number of years. For example, I have an "invoice due" date column, and then a column next to it saying "number of years." That number of years can be every (1) year, every year for two years, every year for…
Hi, I would like to count the occurrences in the current month and previous month. We use Australian
Hi, I would like to count the occurrences in the current month and previous month. We use Australian date format. I have tried IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), but this is not giving accurate information.

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