-
Pivot: Add Row Links from source sheet
We're starting to dive in a make use of the Pivot app, and it is extremely powerful, however we are finding that it would be extremely useful for users to be able to affect the base data from the Pivot sheet more easily. One idea I have would be if there was a link in the Pivot sheet for each row directly to that row in…
-
How do I have a Dashboard show only 100% not 150%
Please see below example. I want to only show 100% as the top, not 150%. Is that something on the sheet itself that I need to do? If so, I only have a % Complete and % Remaining columns. What would i need to place in there to fix this.
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
Counting and Averaging with Exclusions
Hello Smartsheet Community, My organization uses Smartsheet to track our recruiting efforts. Each of our divisions has its own sheet, and we have a metrics sheet to tie all of the divisional sheets together. I am having issues both at the divisional sheet-level and the metrics sheet-level. Problem 1) Sheet Summary…
-
How can I create new entries/rows and make sure the link's rule applies automatically to them all?
Hello All, I created a mother sheet called Product Development which we populated via it's online form. I created a secondary sheet ( daughter sheet) called Costing in which the majority of the columns are linked to the rows in the mother 's sheet. I added a new last row but the Links to the secondary sheet are missing.…
-
How to Use VLOOKUP and SUMIFS
I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a summary sheet that lists the Case ID, each reviewer, and then the total time spent on each case. What I would like to do is on…
-
Always pull in the value from the same cell
I'm trying to pull in a text value form a 2nd sheet. The value I'm trying to pull will always be in cell [TextToPullIn]1 for example. That second sheet is populated by a form with the latest entry always on top, and the text I want to pull in my first sheet will therefore always be in the same cell. Any ideas? Maybe I'm…
-
Is there a formula in smartsheet that would create a 2 way link between cells?
Hello, I have multiple sheets that I would like to link all into one Master Sheet. I want the cells to have a two linking methods between each other. If a cell changes in the Master Sheet, I want it to reflect to the other sheets and if the other sheet decides to change the cells, it would reflect back to the Master Sheet.…
-
Formula to calculate date
Hello, I am trying to work backwards but I just don't get it. My event date is my constraint, I want some tasks to be completed x days prior to the event and Smartsheet to calculate the start date of the tasks automatically. For example, send agenda to attendees 2 months prior to the event. I've tried playing with the…