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.

Cross-Reference, confused...
on sheet 1 "TCP Submissions" I am given a priority. This priority needs to look at the current TCP Review Board Date and the second sheet to calculate the date the priority is due. It needs to look at the Analysis Priority on the TCP Submissions sheet (1-5), then match the value AnalysisPriorityTypeDropDown that factors in…
cross sheet cell population/formula
Hello, I'm trying to build a formula that references two sheets, where if the cell @ row is the same name in one sheet (column Study Name) and the 2nd sheet, then the contacts from sheet 2 populate. Here is my current formula, which is saying unparaseable. Any thoughts? =IF ([Study Name]@row = {Greenphire Study Intake &…
Index match formula
=INDEX({MASTER - Customer Invoice Log - Status}, MATCH({MASTER - Customer Invoice Log Profit Center}, [Profit Center]@row, {MASTER - Customer Invoice Log Inv Year}, [Invoice YEAR]@row, {MASTER - Customer Invoice Log Inv Month}, [Invoice MONTH]@row, 0)) Can someone tell what Im doing wrong. The column im trying to match is…
Matching Company Name Based on Member Name Chosen
Hi There! We have sheets called Meeting Trackers that we log the name, company name, and company category of the attendees of each workgroup meeting. We have 30+ meeting trackers that we've maintain between 5 meeting facilitators. Through Power BI we collect all the Meeting Tracker information and it should give us what…
CountIFS w/Three Sheet References
I am trying to get a CountIFS formula to work that includes three sheet references and I get errors no matter what I do. I am trying to count the number of tasks with the isParent checkbox not checked, the Status equaling a specific value, and the Category also equaling a specific value. The values are represented in the…
Index match from separate sheet
I can't seem to find the answer to this. I have one worksheet that contains a list of countries and a second column that lists the amount time to fill a resource in that country. In a separate sheet I would like to select one of these countries from a drop down and then have the time to fill from the other worksheet…
When a parent is marked complete how to mark remaining children tasks complete
I have a list that has many parents in the sheet and below that are 4 children tasks. Each have a due date. Not all will need all 4 tasks. How do I have it so when then parent is marked complete it will mark the 4 children tasks complete. This way it will not send notifications if overdue since they will be marked…
Formula
What is wrong with my formula? Looking to calculate how many new circuits and how many disconnects are in each of my 4 options. Metric Sheet: Proj Plan :
Creating multiple graphs in a dashboard from one report or source sheet
I feel like I'm missing something - using only core applications, is there a way to create multiple charts in a dashboard for ongoing data (meaning every time a row is added I want the graph to be fluid to update accordingly from one report?) My understanding is if I'm selecting from the source sheet, its stagnant data and…
Can I attach a form to a Gantt chart to be sent out automatically when milestone is met?
I want to attach a form to a Gannt Chart, so that when a specific milestone is met, the form will automatically be sent to be filled out. I am using the Gantt chart to track multiple jobs, and I want it to send out checklists at certain times during the job process. I created one of the checklists as a form in another…

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

Using JOIN/COLLECT and an OR?
I'm trying to write a formula using the JOIN and COLLECT options. However, I've hit a sticky point when I want to include an OR criterion on the COLLECT portion. My current formula (which works perfectly) is: =JOIN(COLLECT({Assets Range 1}, {Assets Range 2}, [Tool]@row, {Assets Range 3}, "Live"), ", ") However, I want to…
INDEX/COLLECT with both MATCH and CONTAINS criteria
I am looking for help with a cross-sheet INDEX/COLLECT formula. I need to MATCH in one criteria and CONTAINS in another criteria. I can get them working separately but I don't know how to combine into a working formula. Source Sheet: Destination Sheet: In the Attending School column in Destination Sheet, I'd like to…
Parent Color Symbol, Based on "Average" of Child Symbols
Okay, here I am again! On the Project I am working on, the Stakeholder wants parent rows for no reason other than to be able to expand and collapse the data. I nicely suggested that since the data would only be for 1 year (broken down in quarters and about 5 users listed each quarter), that since the data was not excessive…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags