-
Return Multiple Rows Using VLOOKUP and COLLECT
Good morning, I am working on a formula which will return multiple rows of data from a different sheet based on criteria. For context, I am looking to view all the cells from sheet A (defined in a range) where there is a value like "BA Edit" in sheet B. I have tried doing this several ways, with no success.…
-
Drop Downs
I'm using multiple dropdown columns on my smartsheet, most work, but a couple don't. When I try to click on the dropdown, nothing happens. Not sure why?
-
Mindmap / Spider Web views of parent/child and relationship dependencies across worksheets
Hi Has anyone looked at or know of a way to create a more interactive dashboard of a mindmap / spider view of worksheet relationships and parent child dependencies within? I am using smartsheet to manage organisational OKR's and whilst I can create traditional grid/card and even dashboard views the OKR tools I am seeking…
-
Sum a column of numbers only if they meet certain criteria.
I hope this makes sense. I am trying to add up all the numbers is column "Slides". But I only want to include the numbers if the done is not checked. I also not not want to include the number if column "Status" says Scoring Complete. Column "status" has many different options in it. I only need to total to be in one cell,…
-
Conditional Formatting not working as expected.
Hi, Excel: 2016 Version. I am creating conditional formatting dynamically from VBA with the below code every time when I opened my excel. The rules are getting created, but they are not highlighting the max and min value in a row (conditional formatting 3 and 4). I am so confused, anything I am changing in this code is…
-
Help on IF Formula - Multiple Statements
Hi! I need some help on a IF Formula statement. On my sheet, I have a column that is using this equation - =IF([Total ALL Athletes and Unified Partners]@row = 0, "0", IF([Total ALL Athletes and Unified Partners]@row <= 5, "1", IF([Total ALL Athletes and Unified Partners]@row <= 74, "2", IF([Total ALL Athletes and Unified…
-
Automation 'Copy to another sheet' doesn't work
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1. I've tried a couple of times and non of my rows are copied. To test it, I added to the same automation rule to not only copy my rows, but also send me a notification when this field…
-
Adding Vimeo Showcase to an existing Dashboard (via the web content widget)...
I can add a Vimeo video successfully to an existing Smartsheet dashboard, however for some reason I cannot link a Vimeo Showcase in the same way? I get the following error message Invalid URL or embed code. URLs without https are also prevented. Select the link above to see what content is supported (which takes me here…
-
Tableau Online
I have a license for Tableau Online and I created a Dynamic Dashboard in Tableau Desktop. When Shared the dashboard to create a Link and put it in Smartsheet always for user and password for tableau. How can I add a widget link of Tableau in Smartsheet Dashboard for my Smartsheet users without asking me the Tableau…
-
Functionality of dashboard with Forms on it
Hi, Created 3 forms for doing employee reviews with underlying grid sheets. 1 form is an Employee Self Review, 1 Form Employee Selection, and 1 Form Reviewer Form. Idea is a employee fills out self review, then sits with manager. Manager opens dashboard, selects Employee from Employee Selection Form, then clicks submit.…