-
Keeping Parent Card / Subtask relationship when moving card to another sheet.
Hello everyone. I was wondering if there is a way to keep the relationship between a parent card and its subtask intact when moving a sub-task between sheets. In our case this would be various departments who are assigned a sub-task then the card is moved to that departments board. When complete, the department would move…
-
Formula / Multiple Sheet Reference Assistance
Hello! I have a summary sheet that references five sheets. I already had to modify my ranges for VLOOKUP on those sheets because I hit that 25,000 cell reference within moments. Three weeks later after changing all of my sheets, I'm ready to proceed to the next step in my project. I have one column that uses a VLOOKUP to…
-
Web form and linking
Dear all, right now I am struggling a bit as I'd like to implement a web form that is forwarding information into a master table from which the new added row should be directly linked to further sheets to be evaluated and qualified. I had a look in former threads and tried the reporting function, but this won't let me…
-
Copying Links of a single cell to multiples on another sheet
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 candidates on a second sheet. Functionality-wise I want a change in the master board to immediately update on the secondary list…
-
Linking pages
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 one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have…
-
Help getting started
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 everyone has anywhere from 5-30 projects that are either being actively working on or are in the pipeline. I am looking for the…
-
How to use data from another sheet as selection criteria?
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 able to refresh automatically on a daily basis. Any recommendations how I should approach this?
-
Cross sheet formula - help
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 checkboxes. Do I have to leave these in the same sheet? When I tried to do the values in a new sheet by referencing the main sheet…
-
Referencing sheets
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 filter what is needed (to a point) with reports but it still doesn't give me the end result I need. Here is the breakdown in a…
-
If statement to auto link to different cells
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 of the above info to the dashboard but is there a way we can have a formula that automatically links to the corresponding…