-
#NO MATCH result with INDEX/MATCH formula referencing Auto-Number/System
I use the INDEX/MATCH formula across many of my sheets for many years. This is the first year I've encountered this issue: my formula is indexing information referencing an auto-number system column type. We generate 3-digit "reference IDs" in this auto-number column to make it easy to index information for that respective…
-
Technical Issues with Formulas in Smartsheet
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering…
-
Random Number
How is it possible that there isn't a RANDOM() function in Smartsheets to generate a random number of a specified number of digits!? Am I just missing something? Anyone have any clever workaround? Just need a random number to start with that I can do further manipulation with...
-
Create way to reflect quarter?
Dear brains, I have the following setup that I need some suggestions on: I have a database that captures planned travel across the year, and is captured just before every quarter for the upcoming quarter plus one month (so for example, the db will be populated in September for Q2 travel from October - January, but January…
-
We have two forms where data is being submitted but it is not transferring to the Smartsheet grid.
Something is amiss. We have received submissions from two Smartsheets where the data is not transferring. One sheet has 14 submissions and the other has 18 submissions. Where's the data? Is it lost for good or is it just out there in the data sphere looking for a place to go? This is the first time that we have encountered…
-
Nested ranges in INDEX/COLLECT??
I need to pull in all of the email addresses from a sheet into another sheet so that my workflow can alert the people listed in that cell. I have the cell set up as a contact list allowing multiple contacts. I need to pull all the emails for "Anywhere US" where the level is "Major" into the sheet that has my workflow when…
-
Why are columns not printing in the width that I've set them on the report?
We have a lot of people complaining about the size of the reports when they print. We would like the content on one page, and when we shrink the column width in the report it still stretches out when printed making the font very small. Is there a way to maximize the page similar to excel when you pick the "fit columns on…
-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…
-
Meeting Management - Implementation of Template Set
Hello All, Has anyone implemented the Meeting Management template set who would be willing to share what works and what could be improved? We are looking at moving our minutes into Smartsheet (obviously), and I would like to understand a bit more. The "Getting Started Guide" for the Meeting Management template set is a bit…
-
Merged: Trigger a Data Shuttle Action via Automation Workflow
This discussion has been merged.