Hi all,
I have a smartsheet which is an 'adverse events register'. When a form is filled out, the person will tick if this adverse event is a 'security', 'estates' or 'health and safety' event.
Both the H&S and the Estates teams have smartsheet licenses, and have access to all of the information in the whole sheet. The Security team does not have any smartsheet licenses as these adverse events (around 10-20 a year) are the only things they use Smartsheets for.
We have a workflow set up to alert them when a row is relevant to them - the row is sent to them, and they are able to add comments to it. We would like them to be able to actually edit text in the row, though, as opposed to just attaching comments to the row as a whole. Is it possible to give them access to edit the row, without giving them access to the whole smartsheet?
Alternatively, we have been looking at setting up a workflow to copy rows related to the security team on to a security-team designated Adverse Events register; however:
a) will they be able to access and edit this type of smartsheet without a license?
b) if they can access and edit this security specific smartsheet, is there a workflow or formula to enable any edits done on this Security Adverse Events register, to automatically show up on the original master Adverse Events Register?
