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.
I have provisional users who, under the legacy model, were unlicensed users with editing permissions for workspaces. I’ve now changed their role to "viewers" and assigned editing permissions to specific workspaces, aiming to maintain the same editing experience as before. However, they cannot edit fields within tasks or…
I'm creating an offboarding checklist sheet which sends out automation notifications to relevant parties in each department. Notifications are sent out when the termination goes live, one week after the termination date (if that department's tasks still aren't checked off as done), and two weeks after the termination date…
Does sharing a sheet with edit or view rights immediately require the shared user to have a paid license, effectively making them a group member? This seems to be occurring. In contrast, can I confirm that sharing a link using the 'publish' feature will not require a license since the user is only accessing that specific…
