Formulas and Functions

Archives for August 2023

Smartsheets Countifs and Month filtering Error
Hello Smartsheets community, I am having some trouble with this code as I am not getting the answer I want. Any help would be appreciated! =COUNTIFS({CBOM - Yellowstone Range 1}, "N", {CBOM - Yellowstone Range 2}, "1", {CBOM - Yellowstone Range 8}, "MONTH(@cell) = 9") Thank you!
Vlookup Date into another Date field - #DATE EXPECTED Error
Hello, I am using a VLOOKUP to pull a date into a sheet from another sheet. Both columns (date source / range, and destination column) are Date column types, but the destination sheet is returning the # DATE EXPECTED error. I thought if you were pulling a date from a date column, into another date column, the return value…
SUM(COLLECT/SUMIFS( based on multi-select
Hi everyone, Does anyone have a formula already handy that does this? Looking to SUMIFS values where the variable is one of the options in the dropdown value? This is a cross sheet formula pulling from a table where there is only one country per cell, but looking to aggregate (show me everything in this region).
Why am I getting No Match error?!
I am using this formula above - the price with tax and product name are on a second sheet. Ideally, what I would like for it to do is when the product is chosen from a drop down list, it searches the other sheet for that product and return with the price with tax to populate the cell.
How to combine two rows of non-numerical Data?
I am working on a project where I learned that the clients first name and the clients full name will be required. I currently have a column for first name and a column for last, and I would like to combine those two to create a full name column. I tried adding both of them together, which worked but didn't include a space…
Can I use a formula to copy the date from my "Target Date" column to my "Projected Date" column?
I'm working on creating a project status dashboard to share with stakeholders at my company so they can easily understand where each project stands. I have a "Target Completion Date" column and a "Projected Completion Date" column. I'd like to be able to use a formula so that when the "Status" column says "In Progress, On…
Running Sum of a column with a given Criteria
Looking for formula help to provide a running sum of all the guests registered to attend a function on a given day.
Cannot Figure Logic or Syntax for Nested IF, AND, and OR formula
I have been unable, after 4 straight days of trying, to figure out this formula. I am a novice with Smartsheet. I need a Finding Overdue column (checkbox type) to report if a finding is overdue. Closed findings are automatically not overdue. Open findings have a deadline; however, the deadline may be extended, in which…
MAX function -most recent date
I know this should work, but it's not. I am referencing other sheets and pulling in the max date. I am getting an unparseable in return. What am I missing? If I put just one "HOUDATE" it's invalid. yes - I am pulling from Date column types. Thanks!!
Trouble Setting Up a Workflow Automation Asking for Additional Information
I want to send an individual in a row a request to provide updated information to a sheet using a workflow form once the Send Request is checked. However, when trying to select the "Send to Contacts in a Cell" it doesn't give me the option to select a contact field with their email. Also, I want to pre-populate their…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Can't get IF formula to work,
I have two columns with numbers, and one column with at checkbox, I want to use IF to automatically check the box if the cell in column 2 I bigger than the cell in column 1. This is my formula in the the checkbox column =IF([Column 2]@row<[Column 1]@row) 1, 0 But I keep getting the Unparseable message
Invalid Data Type Error
I have two formulas on different Grids doing the same thing. Formula 1 works, but formula 2 does not. I have double checked the data types of all references and they are the same in both formulas. ={T-Cost} * SUMIFS({T-Total}, {T-Date}, AND(MONTH(@cell) = $Month@row, YEAR(@cell) = [2024]$1)) ={Tourn - Cost} * SUMIFS({Tourn…
Percent formula for drop down fields
I have a column with the following options for drop down fields: NA, Not Started, Required, Drafted, Posted What formula can I use to show me % complete (posted) without taking into account the NAs?

Formulas and Functions

Discussion List

Help Article Resources