I am trying to get 2 sheets to work together. Meaning when I have a certain word or phrase I would like it to link to another sheet. How ever it can only be that word or phrase or nothing else.
I need help
Thank You
=if(find("Phrase",[Column2]1)>0,{link to cell in other page},"")
URL Posted below is help on referencing other pages
https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
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…
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…
