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
Looking to take a parent row on the pulled column and put a percent complete of the children rows.
Adding "Months" to a Date (Column)
I have a Column [Planned FPI] 01/02/23 that I want to ADD a # of Months [Estimated Duration (Months] to and I can't get the formula to return a Date.
How can I visually group rows together using automation?
I am in the process of moving information from Google Sheets to Smartsheet. I would like to automatically apply formatting to a group of rows to indicate that they belong together. In Google Sheets, I would use borders to separate orders. This would indicate to my team and a group of items belonged to the same order…
Display header rows only if there are additional rows on the same date
I'm building out a production schedule and am looking to create a formula that would help me only display a header row (grey) if there's an associated line item on that same date (white). Ideally, this would hide Saturday 6 April and Sunday 7 April (until/unless we add an item on that date at a later time. Is that…
Index Match Issues - #NO MATCH
I have 2 sheets. In sheet 1, I am trying to output the project names based on matching PO# values between sheets 1 and 2, sheet 2 has corresponding project names. I am getting a #NO MATCH error. My first thought is that this is happening because there are multiple lines in sheet 2 with that PO# and Project names. My…
Using duration column for automation workflows
Hope you are well! I'm using this function: https://help.smartsheet.com/articles/2479251-condition-blocks-filter-what-your-automated-workflows-send However, instead of generic numbers, I want to use the duration column for the condition like below: I tested it and it's not working. Is there another syntax I need to use to…
Return Current Month in Cross Sheet Formula
Hi all, I need to pull counts of events related to account #'s for the current month. On the raw data sheet, I have the row calculation working with this formula: =COUNTIFS([Event Date]@row, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), [Event Date]@row, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) However, that will just return…
Need Help Calculating % Change (increase or decrease) Between Two Numbers
This discussion was created from comments split from: Need Help Calculating % Change (increase or decrease) Between Two Numbers.
SumIF using Contain
Hello, I am trying to write a formula to sum a column if a criteria in another column is met. Column to sum : Amount Criteria column name : Status Criteria to be met: Completed I am trying =SUMIF(Status:Status, CONTAINS "Completed", Amount:Amount) but getting #UNPARSEABLE ERROR. Also, is it possible to include multiple…
Formula to prevent wrong input
Hello, I need a bit of further help. I have two columns A & B for inputting numbers. A is the upper limit and B the lower limit. They are both required to be filled. It is quite possible that the persons inputting the data may inadvertently put the lower value in the upper limit column (A) and visa versa. Can a formula be…
Help Article Resources
Trending in Formulas and Functions