Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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
Hello everyone seeking for an answer and help please im having a hard time on approval request automation . My workflow runs smoothly however when the approver open the attachment on the request it automatically downloads and when clicking the approve it says link are already used and auto decline teh approval request…
I am building a dashboard showing data entered into 1 overall workbook. Teams have been given a target amount to hit, so I have also created a second sheet showing a chart/grid that rolls up all the information and compares against targets using formulas calling back to the initial input sheet. If I publish this roll-up…
I have a very simple use case: a sheet contains a Status column with values such as Completed, On Hold, and In Progress. I would like to create a dashboard chart showing the count of items per status. This feels like a basic capability that tools like Excel handle automatically by aggregating categorical values. Why does…
