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
Sign in and
ask it here! The community's got your back.
📈
Wondering if there’s a problem?
Check out the
Status Page and subscribe for notifications.
💡
Share your knowledge!
Help others by
answering questions.
Discussion List
"Project Requirements Matrix" excel Template
I am trying to import a excel template into Smartsheet but when I do the formulas are all out of sync. The template was on the Smartsheet website but whenever I click on the "Click here to Create in Smartsheet" it asks me to sign up for an account. Manually uploading it just makes it very cumbersome due to the formulas…
Auto populate formula column not showing up on report
Hello! I have a sheet with a formula to auto populate a checkbox is a status is entered. The checkbox formula works on the sheet, but when I created a report to pull the checkbox column, the column is empty and will not show the checkbox. Did I do something wrong? Is there a way to populate the column in the report and…
How to countifs "<1"
Hi Smartsheet Community! I have a calculation sheet and I am using COUNTIFS to pull the count of each option in a range of <1,1,2,3,4,5. These criteria were not chosen by me and must remain as is. I am easily able to do this for 1-5 but Is it possible to use COUNTIFS to count how many "<1" there are? Is there a better way?…
Formula : Date & Time Column
Can anyone assist me with a formula to show Column 1 - Column 2 = Column 3? Sounds easy enough but the Date/Time column is throwing me off. This is an existing sheet so they don't want me to change the formatting on Column 1 or 2 if possible. Column 1 : Created Date (Date & Time) Column 2 : Modification Date (Date & Time)…
Multiple ifs when looking at child tasks
Hi All I've got this formula which checks if a line has children then if any of them are "RAG" Green it prints a 1. I am using it to create a report with nested line items =IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIFS(DESCENDANTS(RAG@row), "Green") > 0, 1)) I am trying to limit returning "1" only if any of the…
Countif Formula help!
I am looking to get totals for each employee (in the last 182 days) for each error type up in the master section but my formula isnt quite working =COUNTIFS(Staff:Staff, @cell = Staff@row, Date:Date, Error:Error, @cell >= TODAY(-182)) what am i missing?
Index collect with checked cell
The formula works fine, but what I really want to is that the IP (in column3) would only appear when the check mark (at column2) is checked. Is there anyway of doing that? Can anyone help? Thanks!
tracking # of employees quarter over quarter
I'm trying to show on a graph how many employees we had in each quarter. How would I do that? My initial idea is to add a helper column for each quarter, and add a formula to return a 1 if any of the date range of that quarter falls after their start date and before their end date, then pull a report counting the 1s for…
Date formula based on frequency
Hi SS Community - Trying to navigate a formula that will populate a date based on a date and frequency column. Example - when is the next time a document needs to be reviewed (in date format), based on the last date of review and the frequency required (quarterly or annually).
Formulas
hello, I am trying to create a portion on my dashboard where I can show how many items were not approved by the business per workstream. I can count generally how many were not approved but not sure what formula to use to insert the detail " by workstream". I use "COUNTIF" should I be using a different formula?
Help Article Resources