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
Meeting Minutes Filter – per published item formula
I have created a meeting minutes filter where when I select the published date (or meeting minute #) it will publish only the date of that particular meeting minute date it was created or any due date falling on that date. What I want to add is the attendees list for that date, where I want to put an X in a column to…
create a graph horizontally that that can show estimated duration in days
I have a construction budget listed vertically, its all calculated in days and now I need a estimated task bar horizontally foreach line for estimated duration in days and actually duration in days
Strange COUNTIF problem when referencing checkbox column in a different sheet
Dear Smartsheet Community, I'm observing a strange problem and not sure whether it's because I'm doing something wrong: I've used the COUNTIF function many times to count the number of checked checkboxes in a column, for example using =COUNTIF(CheckboxColumn:CheckboxColumn, TRUE) - and using the 'FALSE' equivalent to count…
Issue with leading zeroes when Identifying duplicates
I am using the following formula to identify duplicate invoice #s in a spreadsheet. I've noticed that the formula does not work when the invoice # starts with a zero. It works for all other formats: text, numbers (without leading zeroes), dates. The column property is set to text/number. What could be the issue??…
Formula to Turn Number into Date
Hi Smartsheeters! We currently have another system feeding dates into Smartsheet in a number form. For instace, this number (1695686400000) is sent to Smartsheet represents 9/26/2023. How can we convert that number into a date value in Smartsheet? Thank you for your help!
Requesting help reporting top three vendors for three locations based on a common review database
Our team is trying to build a tool to intake vendor reviews based on five averaged criteria to inform vendor selection on future projects. I've built the form, a review collection database, a review metrics helper sheet, a vendor masterlist and a preliminary report. I'd like to be able to consistently report the top three…
Formula question - cross sheet reference with multiple criteria
Hi all, I'm trying to calculate the total registration fees from confirmed people =SUMIF({In-Person Registration Status}, "Confirmed",{Attendee Individual Cost}, > $0.00) I have several needs to create cross sheet references that are looking for specific criteria and creating sums so any guidance would be much appreciated.
COUNTIFS Question
Hi, I have a spreadsheet of various columns which includes, in part,: Original Location Current Location Duration Since Move to Original Location I am trying to create a COUNTIFS formula to count how many people are not at their Original Location within a time frame of 365 days. This is being done on a separate sheet using…
Unique Count based on @cell
I'm trying to count the number of EIDs associated with each New Area. Below I would hope htat next to Metro New York I would get a 2 and Gulf Coast I would get a 3
Formula for looking up values from one sheet to another using IF
Hello, Would anyone be able to suggest the best formula to use for pulling information from first sheet to a second sheet if the criteria on a column of the first sheet is "yes"? Basically if Column #48 of Sheet 1 is marked "Yes," then transfer the data from Columns #7 and #9 of Sheet 1 into Sheet 2. I tried an IF /…
Help Article Resources
Trending in Formulas and Functions