-
is there a way to run a report on all cell history data?
I currently click on each cell for its history. How can I run a report on all cell history?
-
Automation to Copy specific Columns to other Sheets
I love the automation to move over rows automatically, but being able to choose which columns data is moved from would be ideal. We use a sheet to track our recruitment efforts (with interview dates and other information) but when we hire someone, we don't need all the misc. dates and information to come into our current…
-
Group Management Reporting Capability
I would like to be able to run a group report showing all the group names as well as those who are included within the groups.
-
Trying to set up a Round Robin for techs based on project type and if they are not out on leave
Hello I have been searching for a way to auto-assign a tech in a round robin flow based on what type of project it is . i.e only persons A-N should be assigned to the following types Decom, Darken While persons O-U should only get assigned to (or possibly any project type above or below) Go-To, Downsize, Refresh, Build…
-
Enhancement Request - Multiple Rows From a Single Form Submission - Multiple Lines
Having the ability to create multiple line item entries on a single form. Meaning, let's say you create "header" information 1x on a form, but then enter multiple Line Items (which end up as separate rows) rather than having them extend into multiple columns. Data is not user friendly by any means in this current format,…
-
Report: Right-Click Header, "Group by this Column" and "Summarize this Column"
In Reports, It would be GREAT to be able to right click on a column header and add that column as a group or a summary. The options would be: 1. Group by this Column 2. Summarize this Column And then when you go to the GROUP or SUMMARIES menu, you can then select how you want it summarized or grouped.
-
Ways to find what reports are running a certain sheet as it's source data
I want to make some structure change to particular sheet. (Especially Primary column) However, before I can change that, I need to find out how many and what reports are using this sheet as it's source to make sure nothing will break. Anything used in cross-sheet reference formulas are easier to find out but Smartsheet…
-
COUNTIFS using only distinct/unique values
Hi! I'm trying to count each row that 1) has the Parent Row checked, then 2) each of those that has a unique value in the Row ID column. (meaning if there's duplicate numbers, like rows 0062, I want it to only count once). Not sure what that formula would look like. Thank you!
-
Rows randomly reordering
I use a shared sheet and the rows will randomly change. We've looked at filters and rules but nothing would trigger the changing of the rows. Anyone else having this issue?
-
How can I filter out values on Timeline view?
When I create a filter all the dropdown values still appear. I am using the Timeline view to show a roadmap of upcoming projects. There are 40 projects listed but only 20 have been assigned to an area. I have a list of the 12 areas who could be assigned a project, currently on about 6 areas are assigned a project. The…