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
- Good morning, Hoping someone can help here. Is there a way to stop automations/update requests from running on Saturday and Sunday? Automated emails/update requests are being missed by staff since the…
- Hello, I'm trying to count the number of entries created in a month, based on the timestamp from the system generated Created field. I am able to do this with a helper column, where I perform the Mont…
- I am trying to generate a date in one column based on an input from a drop down in another column. We have 3 complexity levels Low, Moderate, and High. Low equals 7 days from today, Moderate equals 17…
- Good day, I am looking to Aggregate Red/Yellow/Green status into one overall R/Y/G. Here is the criteria for grade 1: All classes are either yellow, or green, overall grade = green 3 classes at yellow…
- This formula works perfectly fine but for some reason it defaults to 0 until I actually open the metrics page. I use this metric in a dashboard and everyday it changes back to 0 until I open the metri…
- Hello Smartsheet Community Stuck with using Ancestors based formula to do the following: In the process of building a sheet to roll up task and eventutally project information so that as we decompose/…
- Need Help. I have two sheets- Sheet1, has all the Survey Values (i.e, Yes, No, NA), and Sheet2 will have all the Formula. I want to assign a numerical value on the answers of Sheet1. For instance, Yes…
- I have a sheet that lists due dates in one column, and I was wondering if there is a way to use an If/then statement within the symbol column to indicate the following: If the due date is within last …
- how do I create a Week of Date based on dates during the week? For example the Delivery date of 10/21 I want populate the Week Delivery Date with the week number Date. Do I need to create and addition…
- I have a survey going to to people with 56 compliance rules. When the survey answers as "out of compliance" I have a rules column for each rule change that to a "1". Another column I've made have mult…
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…