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.
Discussion List
- Can I change the font of the data label on a bar chart?
- Hi! On my dashboard, I use a Metric widget which is from a sheet and using Today() formula. However every day I visit my dashboard, it's always not display today's date. It must has to go back and ref…
- I saw a formula that automatically checks the box and auto-populates an email someone else fills out, but how do I make sure it goes to the same person or persons every time? Referenced answer here: h…
- Hi We have lots of project sheets which must be got their project end date. Then I use the sheet summary function to get that valuable information from every project sheet. Then I got a report of all …
- Hello Smartsheet Experts, I am new to Smartsheet and Syntax as a whole. I am in need of some assistance. I have a formula to change Mod 1 to "Beamline" if "Tool Number" is above 239000 and if below 23…
- Here is the formula that I have been working with. Currently I have it build out to where it flags duplicates but only if it is a "single-select". As soon as I select multiple times in the cell, it wo…
- I'm making a simple smartsheet and have a column adding several cells. Then have a status ball change colors based on certain numerical conditions. I need the SUM formula to remain blank and not 0 bec…
- Hello! I've been hunting and cannot find a solution to a problem that shouldn't be complicated. I need to add a varying number of months to a date, and spit out a new date. Specifically: Date Opened +…
- Hello, I got a quick question for you amazing people. Long story short, I'm trying to create an attendance tracker that tracks things like tardiness, call outs, pto, fmla, and overtime. I feel like I …
- Hi, I'm trying to connect the symbols to a column for "not started", "In progress", "Complete". Is there any way I can do it? I'm trying to change the text automatically when an assigned person change…
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.4K Get Help
- 465 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.4K Ideas & Feature Requests
- 86 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 519 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Popular Tags
- Formulas 13,734
- Project Management 4,755
- Sheets 4,485
- Reports 3,280
- Automations 3,120
- Forms 3,061
- functionality 2,526
- Dashboards 1,937
- Cell linking 1,805
- Enhancement Request 1,802
- IT & Operations 1,801
- Support 1,765
- Email Notifications 1,748
- Account and User Management 1,562
- Conditional Formatting 1,422
- Workflows in Smartsheet 1,384
- Integrations 1,377
- API and Developers 1,268
- Construction 1,127
- Sharing and Collaboration 1,105
- Update Requests 1,014
- Attachments 977
- 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
- I need a formula that populates the due date based on the date that its approved. I want the date to be at the end of each quarter
- I have a source sheet of different items, rolling out on different dates for different stores. I am creating a target sheet of a rollout of one specific item. I want the target sheet to list all the s…
- = "Not Started" if NO boxes checked = "In Progress" if SOME boxes are checked = "Complete" if ALL boxes are checked for the attached example I manually changed status based on checked boxes, but I'm h…