Has anyone else had a problem copying a link to one reference cell to multiples on another sheet? We have the problem of trying to link a single reference number on a master sheet to a group of candid…
Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for o…
I am very new to smartsheet and am only day 3 of using the tool. I am looking for some guidance or confirmation in my approach to manage the projects of my team. I have about 53 team members and every…
Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be abl…
With this new feature I'm hoping I can eliminate abut 10 columns from one sheet and create a sheet just for totals. Currently I have several columns just for counting the value of columns with checkbo…
I am trying to decide between one sheet vs multiple sheets. I currently have one sheet but it has over 50-60 columns and there are sets of data that will be used by different areas. I know I can filte…
On our PM sheet we have stage summaries which show the % complete, start/end date, and a RYG dot. All of this information appears on a dashboard. Currently when we change stages we have to re-link all…
We have a sheet that lists all of our projects (there are over 300 at the moment). We used to keep all of our metrics at the top of the sheet, but every now and again, someone would sort by a value th…
I have two sheets with several common columns. One of which is closing dates. I want sheet B closing date column to look at sheet A and pull the closing date for each row. The sheets have common colum…
Hi I have a column with a long URL http://blblblblbl... There are about 300 rows in the sheet. I'd like to change the display text of the links to Preview for all of them. Is there a way? I can not do…