Best Of
Re: Getting sheets to talk to one another
If there are just two sheets then they will simply need to use the corresponding formulas from the third sheet in the appropriate sheet that they would like them in, if I am thinking about this correctly. So if sheet A wants to pull in data from B, use the Data B formula. Then reverse the formula for Sheet B to pull in Sheet A. The principle should still work.
In my mind I thought they were trying to aggregate everything into another location not just mirror each other.

Re: Getting sheets to talk to one another
@Brian Wilson DC Thank you for your quick response. There are only two sheets and not three. Is there still a way to make what I need work?
I can confirm that they are “Date” type columns and not a Text type with dates typed in.
The unique identifiers for each sheet are in different column locations within the overall sheets. Meaning these unique identifiers are not the first column within the sheet, much like you would need for an Excel VLOOKUP formula.
Thank you for the not restricted to “dates only” within the “Date Type” setting. One of the sheets had the "restrict to dates" only setting enabled.
I tried the =INDEX({Data Sheet A - Start Date}, MATCH([Unique Identifier]@row, {Unique Identifier Row - Sheet A})) formula you gave within my Sheet A cell to pull from Sheet B the date that I want to display (based on the date I placed in Sheet B in the identified column) and it didn't return a result. Based on my naming, this is the formula I entered into Sheet A cell where I want the data to display: =INDEX({CAR/CORPORATE TRACKING date}, MATCH([CAR code]@row, {CAR code}))
I'm hoping there is a solution. Thank you for your assistance.

Monte Carlo Simulation
Is there a way to run a Monte Carlo simulation in smartsheets?

Re: SmartSheet new user subscription model (USM) - provisional status
100% agree with this statement.

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 employee sheet.

Re: Group Management Reporting Capability
It is a source of extreme frustration for me. I work in higher ed in a very large university. I use groups in dynamic views and in workapps A LOT. They are supposed to make it easier to manage access. Instead of changing users at each artifact, I can just update the group contacts and call it a day.
Some of my groups are hundreds of contacts, and every semester some portion of them changes because students graduate and professors go on/come back from leaves. Am I really supposed to go through the list and manually check off every contact I want removed? My weird workaround right now is to just delete all contacts and reupload the most recent list.
Group Management would be such a useful feature, but as it is now, it is really inconvenient to manage groups that are larger than a handful of people.

Re: Remove Empty Space at Bottom of Dashboard
Ok, I've submitted the request. Here's the link - please vote it up to get it on the list to be implemented!
https://community.smartsheet.com/discussion/134758/remove-empty-space-at-bottom-of-dashboard-after-consolidating-empty-space/p1?new=1

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.

Re: Group Management Reporting Capability
Amazing that we can't have this simple but critical functionality. Requested 3 years ago. Basic administrative function for system/group admins.
