-
Remove all hierarchy (indents) from a sheet
Hi, I have a sheet with about 500 rows, with a lot of hierarchy (indents) within it. My ultimate goal is to be able to sort rows by one of my columns, and not have the indents alter how the rows are arranged after this sorting. Therefore I planned to create a new sheet where I removed all the hierarchy/indents (sort of…
-
Hide Blank Columns in "Print" view
Smartsheet already gives the ability to display hidden columns when printing, but it'd be REALLY nice if you could hide columns that don't have data in them. If you have a huge form (50+ columns) with a bunch of conditional logic, there's going to be a lot of blank columns in any of the sheet views currently available.…
-
CountIfs Function to Determine if Completed on Time
Hi, I am trying to put together a formula sheet from our data in our inventory. Within the inventory, each project is assigned to someone and given a due date, they will manually enter their completion date. I want the formula to count # of projects someone completes on time. Here is my current formula: =COUNTIFS({Assigned…
-
Request Access Notification
I provision all projects for our PMO and each project is housed in a Workspace to control access, so, I am the 'owner' for each project in our organization... This setup worked for a time, but now that we're scaling up, I'm receiving access requests for projects almost hourly. Unfortunately, the way we have our project…
-
Dynamic Dropdown List
Has anyone created a workaround or built a solution that provides dynamic dropdown lists?
-
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,…
-
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…
-
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…