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.
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.
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.
Sort
Hot
▾
Discussion List
- Need to transform the month and date into date format from "Sunday, December 12 4:25 PM"
- I have one drop down column "Turbine Operational" with the options Yes or No. Another column "MW Impacted" is a text column. I'd like to be able to input numbers into the MW Impacted Column, but if th…
- I am attempting to use 2 formulas to separate an address that is comma deliminated, but the formula continually misses the mark. The formulas in use: Street address: =IFERROR(LEFT(Address@row, FIND(",…
- Hello! I'm trying to create a formula based on status color for my office Smartsheet for 2022. It's blank, but I've been putting in test data to try it out. I haven't done this in so long so I'm out o…
- Me again! I have youtubed hours of videos and cannot figure out what I am dong wrong. I have a unit name that I would to automatically return a unit number from our apparatus inventory. The formula se…
- I am trying to do the same autogenerating reference numbers using a column that it is like the project class (What is it?) and the reference date will be the created column date that automatically ass…
- I've got myself going round and round trying to create a good health column formula for the project plan shown below. Hoping you can help with a formula to achieve this for each row/task: Green: Statu…
- I am looking for a way to count the children of a parent row, but only if the children have a particular attribute that is true. I'll then use that count to set up an CountIF to flag the parent row wh…
- Hi everyone, Few questions all interrelated. I disguised my actual field names, but this returns a blank cell.... how can that be? Shouldn't it return either Done or Not Done? I added ,"x" after Not D…
- Hello SS Community. After struggling with syntax for VLOOKUP cross-sheet formula, I found information on index/match. I think this may be the formula and solution that I'm looking for. I have sheets f…
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 466 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Popular Tags
- Formulas 13,746
- Project Management 4,758
- Sheets 4,486
- Reports 3,282
- Automations 3,123
- Forms 3,064
- functionality 2,527
- Dashboards 1,937
- Cell linking 1,805
- Enhancement Request 1,804
- IT & Operations 1,801
- Support 1,765
- Email Notifications 1,749
- Account and User Management 1,564
- Conditional Formatting 1,423
- Workflows in Smartsheet 1,386
- Integrations 1,377
- API and Developers 1,269
- Construction 1,127
- Sharing and Collaboration 1,106
- Update Requests 1,014
- Attachments 978
- Gantt View 935
- Manufacturing 898
- Templates 881
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- QUESTION: How to create a Text string output from a formula that can be copied and pasted into other applications. BACKGROUND: I have a large project that requires many Discovery sessions and have a s…
- I currently have this formula working to return the Store number that is Type - TRH. =INDEX(COLLECT({Copy of Construction-Checklist STORE NUMBER}, {Copy of Construction- TYPE 3}, "TRH"), Number@row) H…
- I am currently using the formula: =INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1) to collect the next task due that is not completed for my summary secti…