Is there a way to link cells, or even just copy cell/row info, if a specific criteria is met? I am new to Smartsheet and haven't been able to find anything to do this.
This is the situation:
I am using a webform to create Purchase requests. I have approvals set up. Once the request has been APPROVED, I want specific cells from the request sheet to link to a Purchase Order sheet. I don't want anything that is DECLINED to link, which is the problem I have now.
Any help would be greatly appreciated!
Help Article Resources
Check out the Formula Handbook template!