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?
Ask it here! The community's got your back.
Discussion List
I am trying to get a unit count between a date range.
I am trying to get a unit count between a date range. I have two difference columns from one sheet and two difference columns on my main sheet I am referencing. I keep getting unparseable. Is there a way to to get the number I want with using the countifs formula? Or should I be using a different formula? This is the…
COUNTIFS formula for any future date?
Hi all, I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date. I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working. Any advice would be appreciated! Thank you.
Sheet Summary Field - Count Value from Dropdown
What's wrong with this Formula? Getting an Invalid Ref
COUNTIF
I need to have the formula capture the project parent in parent row marked with a star in the project row column and the project in in progress - prioritized and in progress - not prioritized from the status column. I am using the following formula but its coming back with a zero: =COUNTIFS({Status}, "In Progress -…
Converting a text (MONTH YEAR) into a date
Hello, I am trying to convert a text box that shows the month and year only in a column. So if the cell with the text of “October 2022” is shown, I want a different column to produce “10/01/22” I would also want to use this date column for automations, so I am curious to know if column formulas could be used as triggers…
IF Formula assistance.
This discussion was created from comments split from: Task Completion Percentages.
index 10 different columns, all with same match criteria
I am looking to index 10 columns from sheet B into 10 columns in sheet A, all using the same match criteria... it is only returning the result in column A1. Like it's processing left to right and stopping after a result is returned. Each of my 10 columns has basically this same formula, only difference is what I am…
Converting Text Into Numerical Value
I'm trying to convert the number 3 that came from the below formula into a value number instead of a text. I already tried putting VALUE in front of the LEFT function but I'm still getting an error message. Any suggestions will be appreciated. =IF(OR(CONTAINS("Pallets", LOWER([# of Pallets/Dimensions/Weight]@row)),…
Formula using Index and Match to reference another sheet only returns first item
I am using an Index/Match formula to lookup a person associated with a specific region. I have a sheet setup as a lookup table named Gift Card Approver with 2 columns: Region and Approver. In my main sheet I have a formula that pulls the region from the current line and uses that to lookup the approver in the Gift Card…
Formula to return a checkbox on Sheet B, if a % column in Sheet A = 100 + move rows
Hello there, I have 2 sheets: Sheet A - Base File, where i have % Column where i input the current numbers. Sheet B - Transfer to File, where i need to add a checkbox to a row, if the % Column in Sheet A is 100 %. I have managed to make the reference where: =IF({Base File Range 5} = 1, 1, 0). BASE FILE TRANSFER TO FILE My…
Help Article Resources
Trending in Formulas and Functions