-
Dynamic Reporting Linking Filters
I would like to make reports dynamic so that you can link filter options to another sheet. For Control center this would be great because you can have the intake sheet (Where the data lives) drive into the report and populate the results. We would like to see it linked so if you change the data on the intake sheet, the…
-
How saved filters work
I'm requesting that the parameters of a saved filter not be updated when I use that saved filter, add some more filters to dive into the data more, update some data fields, then click save. Intuitively to me that "save" should have just stored the data updates and shouldn't have updated the parameters of the saved filter.…
-
Cross-sheet predecessor without using cross-sheet reference
In sheet 1 there is a date 1 which is a predecessor (SF type) for last task in sheet 2, so that date 1 is later than any task in sheet 2. When I use a cross-sheet reference to import the date 1 into sheet 2 and then simply use it as a SF predecessor, it does two things that I need to avoid: it erases the critical path for…
-
How do I create a report that sums totals from my sheet?
Hi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.
-
Request to Restrict Sheet View by Current User in Report
Hi, I'm looking for a way to restrict the view of a sheet so that each user only sees the rows relevant to them. I know this can be done using Dynamic View, but I want users to be able to update multiple rows directly in the sheet, without having to open each row individually in a form. Here's the situation: I have a sheet…
-
Change Dropdown Column Value for Multiple Rows at One Time
Simple question here: I want to change the Dropdown value of multiple rows at the same time. Select Rows, 3, 5, 6, and 8. Change these rows' Column B (dropdown) value to "Value X". Right now I can select multiple rows by clicking while holding shift. But then when I try to change the column value for them all, it just…
-
A Method to Increase the # of Trusted Domains Beyond the 20,000 row limit
There are MILLIONS of domains. We are attempting to streamline our trusted domain list across all our company applications and our exemption request process so approvers only have to approve domains once for all applications, domains are assess and approve consistently and build automations to add approved domains to the…
-
Function for "current user" to use in formula?
Good morning, Is there a function of some sort that I can use in formulas that evaluates to the "currently logged in user"? Use case: I have a Sheet that that has an Assigned To column and a Consult With column, both of which are multi-select Person columns. The Sheet also has a Status column. I'd like to create a Filter…
-
[Control Center] How to rename Intake Sheet? Admin workspace?
Hey there, we're trying to rename our Intake Sheet & wondering what the best way to do this is / anything to watch out for. We would also like to rename our Admin Workspace. Looking for advice before we go messing with anything. Let me know if you need any additional details & thank you in advance!! EDIT: So I went ahead &…
-
Export Column Properties
I would like to be able to export the column properties of a sheet. It would be incredibly beneficial to be able to export the extensive structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only…