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
- I'm looking to record a cell on the first of the month for a report at the beginning of next month. All of my data can change Dailey based on what was done throughout the month or year. As you can see…
- I'm looking to set up a workplace roster on Smartsheet, to cover the 50-odd employees in our workshop. each employee has their own column date tracks row by row each cell tracks daily rostered hours f…
- I am trying to run the networkdays formula based off a certain status. So what I am trying to accomplish is if the position status shows filled, how long did it take to fill? Here is the formula I am …
- Hi Community, I’m trying to cross-sheet reference. After I type the start of the formula, the box to “Reference Another Sheet” appears. I clicked it, found my sheet, chose the column, but the “Insert …
- Hi again, I am trying to have flag a parent row based on 2 separate criteria: 1) if the overall risk score is <50% and 2) if any Children rows have any High Risk questions Flagged I have tried it a co…
- Hello, This morning my dashboard looked normal. A few minutes ago some metric widgets now display #NO MATCH and my charts say "Unable to display chart We're unable to read the source data. Please ask …
- Hello, I am trying to write a formula to look at a due date field and compare it to a status field. If the due date is less than or equal to 90 days from today, the status symbol is green. If the due …
- I am able to have the Status (RYG) show up based on Status (which is tied to percent completed). I am trying to add the function so if the Start Date is in the future the status defaults to Green. Thi…
- I am trying to create a formula where the symbols (red, yellow and green circles) change when red when it is passed the Extension Deadline date, yellow when it is 60 days from the date, and green when…
- so i have sheet 1 with rows 1.Priority 2.Tag Name 3.Blank sheet 2 with rows 1.Blank 2.Cable name 3(would like the Row 1 from sheet 1 and change when I change it in sheet 1) I would like a to make a fo…
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 468 Global Discussions
- 156 Industry Talk
- 511 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,751
- Project Management 4,759
- Sheets 4,489
- Reports 3,284
- Automations 3,125
- Forms 3,064
- functionality 2,527
- Dashboards 1,937
- Cell linking 1,805
- Enhancement Request 1,804
- IT & Operations 1,801
- Support 1,767
- Email Notifications 1,749
- Account and User Management 1,565
- Conditional Formatting 1,425
- Workflows in Smartsheet 1,388
- Integrations 1,377
- API and Developers 1,269
- Construction 1,127
- Sharing and Collaboration 1,107
- 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
- I am struggling to come up with a solution to convert a timestamp string to a date. The format of the timestamp has the month spelled out as in "January 25, 2025 9:15 am." Many thanks, TARA
- I saw someone else asked the same question in another thread https://community.smartsheet.com/discussion/108384/including-a-comma-for-currency-within-an-existing-formula but the answer was very confus…
- I need this formula to return the pay date {pay date} if the hire date [Hire/QE Date]@row is between the date range for the beginning of the pay period {Begin Date} to the end of the pay period {End D…
