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
Formula for at-risk flag, due within 3 days
Hi! I would like to have my at-risk flag turn red when 1) a due date is within 3 days or past the due date and 2) its not completed. I am using the below formula but it doesn't work: =IF(AND([End Date]3 < TODAY(-3), NOT(Status3 = "Complete")), 1, 0) I tried it with making it TODAY() and it works for overdue items, but I'd…
IF formula when multiple options are selected
Hello! I'm trying to see whether or not there's a way to create an IF formula based on one of several options select in a multi-select pick list. One of the fields that my current IF formula is based on has a multi-select pick list. If users select multiple options within that pick list, the formula doesn't formulate. The…
COUNTIFS Question--Calculation vs Filter Results
This formula returns a count of 12 However, when I use the filters, I get a count of 10 Can you help me identify what the issue is in my formula? Why is it counting 2 more cells than the filter? Thank you
Countifs formula across sheets
I am trying to count if the UBMD Dyad (department) on the 2nd sheet (screenshot provided) is any of the ones listed on the 1st sheet and in which month(date column is on the 2nd sheet) it was completed. I was given the formula listed on the 1st sheet but the result is 0. I am not sure what is missing in the formula.…
Can you use a resource as the search-value in vlookup ?
Can you use a resource as the search-value in vlookup ?
Display/Reference data in one sheet in another sheet
Hi Smartsheet Community, I'm struggling with pulling in duplicate data from one sheet into another sheet. I literally want to have Column 1,2,3 etc. display in another sheet. I've tried VLOOKUP, INDEX and using the Sheet Reference Manager but no luck. Any suggestions? Thanks, John
Counting children status
Hi! I'm trying to count the number of children that are "Completed" using the CHILDREN formula and still cannot get it to work after searching and reviewing in the Smartsheet Community. In a separate smartsheet, I've attempted various formulas without luck. Below makes the most sense to me out of the various formulas…
How to count rows if box is checked in separate column?
I have a helper column to identify the columns that require data to be entered. I need help creating a formulat that will do the following: Count the total number of rows within a specific range of the "Entity Details" column, and have a box checked in the "Data to be Entered Column". (For example Rows 10-25, that have a…
Formula Help - Count If (percentage complete)
I'm looking help on a formula to find the "Percent Finished", in row 1 column 1, by counting the total number of "Test Status" entries of: "Completed, Previously Enrolled, Enrollment Not Needed, Client Did Not Approve" and Dividing it by the count of "SAP ID"s. Thanks! Mary F
Converting Time to Military Time
I am trying to convert time entered into military time so intially set it up to add 12 to the rows that clock in and choose PM but then that adds 12 hour to noon making it 24. So I changed the formula to the one below but it is not working correctly? Appreciate any help!! Thank you so much!! =IFERROR(IF(AND([Start Day -…
Help Article Resources