-
Merged: Include column description in Report
This discussion has been merged.
-
Individual Customer Report
Hello, I have a smartsheet form and sheet that I have created reports and dashboards on. The form has many submissions from customers. Many customers have made multiple submissions to the sheet. I would like a report that shows how many individual customers have submitted the form. Is there a way to create this? To note,…
-
Give Administrators full vision and access to all sheets
I recently contacted support about this and was amazed to find that what I thought would be a simple function doesn't exist. We have had staff leave recently and not so recently and have had requests from senior management to look for data that they may have stored in sheets that they may of owned or shared or transferred…
-
Formula Cell Reference Limit (25,000,000) Not Refreshing
Hi all, We're having an issue where the 25,000,000 formula cell reference limit was reached after adding a new column, but even after deleting way more columns and cell references than we added, it's still showing the attached error message and not letting us move any new rows into the sheet. We should be far below the…
-
Is there a possibility of generating PDF of the completed FORMS?
Hi Everyone, I have been working on Smartsheet from few weeks and I believe it makes project management very easy. Have been understanding the optimum use of Smartsheet and implying that in our organisation. So I have a question regarding FORMS. I have created sheets that are connected through automation and use the same…
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
UPDATE: Is there a way to ignore case in a unique identifier
UPDATE: I figured out something about my query below - not all of the doi's on the source and target sheets have the same case (some lower case, some upper). I think this is my issue, which presents a new problem. Is there a way tell smartsheet to ignore case? Or a formula to change case? I'm running into issues where my…
-
Can't find sheets I created
I create sheets and they don't show up in my browse section. The only way I can find them is by searching for it in the tool bar. Does anyone know why that is, and any tips on how I can avoid this? It's pretty annoying and frustrating.
-
How so I get a report to sort in order of date?
This may just be a vent, but I have a report that pulls from about 15 different sheets with archived data from 2024 and 2023. I want the most recent submissions to show first. When I sort the report by the Date/Time column by descending order, it doesn't work. It'll start with 1/1/24 first and work through today (3/22/24).…
-
Updating Status Based on RYGG symbols of Children Rows and RYGG Formula
New day, new formula conundrums! For these formulas, I'm looking to update the status of my PARENT rows (2 levels) based on the RYGG symbol as well as having the RYGG symbol is based the CHILDREN rows' Task Status column. I have both working but I feel like they could be cleaner and just wanted to get a second set of eyes…