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
Date based on the different cell values
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Combine JOIN(COLLECT) and IF(AND)
I am trying to return specific text based on check boxes and want it to list if true. Apples| Apples 1|Apples 2|Apples 3| Apples 4|Apples 5| Apples 6| and so on... I have check boxes under each Apples column where people can select which Apple they want. In the Apples column I want to return a list of their selections like…
Count IF Question - Running Count
Good Morning All, Currently have this column formula called "Count AD": =COUNTIF([Ad Name]$1:[Ad Name]@row, [Ad Name]@row) on lets say Sheet B I have the same formula on Sheet A: =COUNTIF([Creative Name]$1:[Creative Name]@row, [Creative Name]@row) Please Note: Sheet A Creative Name = Sheet B Ad Name Sheet B is generated…
Percentage Complete not totaling 100%
This Month-End Checklist below has the same countif formula in both rows. January totals 100% and February only 96%. What am I missing? This is the formula It's counting the check boxes.
How can I return a value in one column from another sheet based on two inconsistent string criteria?
Hi, any help with this will be hugely appreciated. On my master sheet I have a "Task Name" column, an "Audience" column and a "Description" column I want to populate with this formula. On the source sheet I have a "Task Name" column, an "Audience" column and the "Description" column I want the data from. Unfortunately, the…
Hello All, How do I create an auto numbering system based on a value in another column?
The item number used more than one item should have increasing sequence numbering pattern. for example 8540-0001 line one should have seq #1 and on line at used again should have seq # 2.
Highlighting duplicate values in a column
Hello, I created a helper column with this formula =COUNTIFS([Supplier Lot #:]:[Supplier Lot #:], [Supplier Lot #:]@row) so I can set a conditional format to highlight duplicate values in this lot supplier lot column. However, I noticed that duplicate values are not highlighted if the values have zeros in front of them.…
How to removed #DIVIDE BY ZERO
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
Average or Average If with Sheet References
I tried using a formula created by the Generator, using cross sheet references to pull the data into our metric sheet, and received several errors. We would like to receive an average capacity percentage for an individual PM; the Generator provided the formula below, but if I inserted sheet references in lieu of column…
MAXIFS Formula to generate the latest date
I'm working on building a Smartsheet workspace for our facilities team to track recurring maintenance tasks, and have had issues finding a formula that works the way I want. For context, I'm hoping the end result will be comprised of: 1) a maintenance log 2) a maintenance overview sheet, which shows the most recent "Date…
Help Article Resources
Trending in Formulas and Functions