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
How to split the content of one cell into separate columns
I have a cell with data in this format: Approved,AAD:tammy.couch@transcoretech.com , 9/3/2019 11:06:50 AM I already have a formula for the Status Column, which is Approved. That formula is =IFERROR(LEFT([MFG Approval (archived)]@row, FIND(",", [MFG Approval (archived)]@row) - 1), ""). It works great. However, I need to…
SUMIFS with sheet reference
I've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.
Copy parent row only
I have automation set up to copy rows marked as "key deliverables" in my project schedule into a separate, key deliverables status tracking log. Unfortunately, when a key deliverables row in the schedule is a parent row -- i.e., has subtasks under it -- the automation (rightfully) copies the parent row AND its child…
All tasks, no subtasks into a report or dashboard
How can i get all tasks from various sheets into a report, without the subtasks. They have the same columns. I want to view the Gantts for all tasks without the subtasks taking space.
SUM(IFERROR(INDEX(COLLECT(MATCH))))
This discussion was created from comments split from: SUM(IFERROR(INDEX(COLLECT(MATCH)))).
Accumulative Formula Required
Hello! We require a formula that calculates the PRODUCTION PACE for the completed builds in a financial year quarter. Currently we have the Pace calculating off the completed builds/ number of days in the qtr, but this means that the pace is really high compared to how often we are actually completing a build. I want to…
Need to filter the data in dashboard by month
Hi, I have a customer feedback data captured on the Smartsheet, and i have created the dashboard for the same but in dasboard i need to filter the data by month. Is there any way to achieve this?.
Help with COUNTIFS
So I am trying to make a metric sheet that uses a COUNTIFS sorting by month, year, lane, and to only count if approve is check. I will make a dashboard that eventually sorts by the lanes (3 of them in total) and it will be tracked for trends in change in months and years. Below is the sheet that is connected to a form…
Why are my reports pulling in other informataion
I have a report that I have filtered to pull in tasks for individuals. It's supposed to pull in any tasks that do not have a status of 'Complete' or 'Not Needed' but multiple tasks are pulling in that have been completed for many months. How can I fix this? Report:
is there a word-count formula?
I have a cell where I need to know how many words there are.
Help Article Resources
Trending in Formulas and Functions
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!
Need a formula for % complete for all phases on the parent project summary row. Row is non editable
I need an average formula in the parent project summary (row 23). Formula should include all phases (initiating, planning, executing, closing). The parent row is un-editable and not allowing me to enter a formula.