Sign in to join the conversation:
Is there any way to merge two sheets of different data into one? See image - i want demographic data from one and then recorded actions from another sheet.
Hello,
There currently isn't a way to merge rows from different sheets into one row/line on a report.
This either will need to be performed manually using cell links (more info on this in the help center: https://help.smartsheet.com/articles/861579-cell-linking) or by using a formula, such as VLOOKUP (https://help.smartsheet.com/function/vlookup) that will reference data from one sheet to populate it in another.
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
When I print my dashboard, the color coding next to the divisions disappear. Any clue to a fix?
Is it possible to sort a report widget in dashboards? We have data that could be sorted by date or by location name depending on the use case. Is this possible? I know the underlying sheet can be sorted by column, but I can't see a way to sort the data in the report widget.
