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
Converting Excel document with Macros into Smartsheet
Hello everyone! Has anyone out there converted any of their excel documents with macros into Smartsheet? What best practices did you use? I have read that macros do not import so this tells me that we will have to look at what the actual macros are achieving and back into how to accomplish this with Smartsheet, if it is…
COUNTIF is a reference to another sheet or is a link
I need help to count if a cell contains any link or any reference to another smartsheet. Not a specific file, but any file. Thanks!
Update Form collected data in the Form view
Hello! I have built a form to gather technical information about a customer's environment. Sometimes the information needs to be updated after the fact. The column names on my sheet are shorthand and then I've spent time elaborating on the form with descriptions, labels, and helper text. I've come across posts suggesting:…
Unique Information in Smartsheet Form
Hello! I am working on a survey in Smartsheet that will request updated/missing contact information from our customers. In some of the questions, we would like to show the customer what we have on file and then have them update if needed. Is there a way to pipe this information into the survey that would be unique for each…
Average Time Since Modified - Sheet Summary
I am working on a sheet and I'd like to get an average days since modified across a sheet using the system modified date column. I came up with the following, but im getting an 'invalid data type' error. =AVG(COLLECT(NETDAYS(Modified:Modified, TODAY()), Status:Status, "In Progress")) I had this working utilizing a helper…
Have Status drive Duration in project plan
I would like to be able to create functionality in my project plan such that: In effect, this is designed to keep the task owner's admin activity in the project plan to a bare minimum. All that would need to do is select Status of either In Progress or Complete, everything else is done behind the scenes. I know that in…
Count checkboxes in multiple select cell
Hi - is there a formula I can use to count the number of checkboxes in a multiple select cell? Many thanks.
IF/HAS/INDEX Formula still continues to index cells even when criteria are not met?
Hi, I am using the following formula to index which clinician has completed a particular type of service. The formula seems to be pulling the correct clinician when the criteria are met but continues to pull a clinician even when criteria are not met (ie for other service types): =IF(HAS(Service Type-Source Sheet},…
Counts with specific criteria and only those in current year.
Hello, I currently have this formula below but unfortunately its counting all rows with "XY" listed as Supplier when [Dated Closed] column has a closed date in it....because of course I'm telling it to in this formula. But how can I change it to only count those rows with "XY" listed as Supplier and Closed Date, when date…
row formula
Hi i need to select a range of cells in a column starting from 5 to last row in the sheet. The numbers of rows increase every day i need something dyinamic: [Nome dell’attività]5:[Nome dell’attività]? Is it possible? Thanks Umberto
Help Article Resources
Trending in Formulas and Functions