Formulas

I am trying to average the "Days Shipped Delta" column from another sheet, based on (2) criteria from columns in that same sheet. (FY & Month) I am using the formula below but it returns #DIVIDE BY ZERO. =AVG(COLLECT({Days to Ship Delta}, {FY}, "FY26", {Month}, "01-January"))

Hello All - I am looking for a solution in SS to maintain our department's inventory/stock. Prior to adding materials to inventory, we collect and report regulatory and material information through workflows and approval requests. Once the workflow is complete and the material is approved, a final email is sent to the…

Create an EMAIL() or CONTACT() function so that email information can be extracted from a contact column. For reference we are trying to get the user's email before the "@" sign to print on a printable pdf. Even if I use a formula like: =IFERROR(LEFT([Contact]@row, FIND("@", [Contact]@row) - 1), [Contact]@row) this will…

Hi everyone! I’m Jonathan from Boise State University (Boise, ID USA). I’m currently looking for advice and best practices on transitioning our department's budget reporting process into Smartsheet. Current Workflow & Challenges: Data Scale: We pull data from four different Excel documents, using Power Query and Power…

I'm building executive reports to show which projects are active by quarter. I have start and end dates for each project to show the active date range. The output I'm looking for is a report showing what was active last quarter. Another report showing what is active this quarter. And what will be active next quarter.…

I have a maintenance sheet that summarizes budgets and pull the latest week's worth of data that is available. The budget buckets are a set of 8 numbers (ex: 12345678). Some buckets start with zeroes (ex: 00123456). I had to build a workaround with another field instead of referencing the 00123456, and I'd love to know if…

Hello! I'm sure this is a basic question that I'm just missing the how-to on. Our orginization has a master schedule for the year. I need to take from that master schedule and populate a different sheet based on a date. For example, master schedule has a column of dates. Multiple rows will contain that date. I need to pull…

I'm working on a project where I want to reference the contact list field in an automation email body, but it only pulls the Name field of the contact list item. Is there a way to get just the email address or does anyone have a good workaround for this?

Hi, I am trying to create a sheet from data that is originally held in .csv files. My goal is to make it so that transferring the data to my sheet should be as simple as just copy and paste. My issue is that two of the fields that I need to copy over are reported in scientific notation (1.3E+004) and I am trying to figure…

Problem: Current Limitations Scale Conflicts: Currently, users cannot easily plot two data series with vastly different scales (e.g., "Budget" in millions vs. "% Complete" in decimals) on the same chart; the smaller metric becomes invisible. Complex Workarounds: Users are forced to create "Helper Columns" (to manually…