-
Dynamic Dropdown Lists
Hello everyone! I am looking to build a Smartsheet that has 2 dropdown lists that are "linked" together, meaning that when a user selects a dropdown value from a cell in Column A, the adjacent cell in Column B (that also has a dropdown list) will present a filtered list of values to the user -- and those filtered values…
-
2 forms 1 sheet
Hello, I have two forms in the sheet. Form A is the one to be filled out first. Form B requires some fields from Form A and other new fields. Form B needs to auto-populate some fields from Form A based on the contact list so If I select Peter in Form B, it should populate the fields from the sheet that Peter tagged and it…
-
Make notification links open in desktop app?
When email notifications are triggered, is there a way to click the link to the sheet and have it open in the Desktop App instead of a tab in the browser? I'm using Gmail and Chrome. Thanks in advance!
-
Copy row automation/keeping rows linked
Is there a way to keep rows linked from the parent sheet to destination sheet? So if we make changes to the row after the copying takes place to make sure that the destination sheet is also updated with any updates that happen in the row from the parent sheet?
-
select data cannot be charted, please select a new range
I am now trying this for 4 days in a row and it's taking me in cycles. I am unable to chart or metric data as a dashboard widget. I keep on getting the error select data cannot be charted, please select a new range No matter if i use a default sheet, please note i am not trying to trend from a row report or a summary…
-
Stacked Bar graph showing quarterly progress
Kia ora, I am trying to show progress on on parent tasks over the year based on quarters, i.e. Task 1 - Q1 = 59%, Q2 = 75%, Q3= 82% Task 2 - Q1= 10%, Q2 = 45%, Q3= 56% Task 3 - Q1= 100% I have colour coded each quarter and am only wanting to to show the current quarter % complete in the graph, thus showing % complete to…
-
Dashboard Calculations -- will they ever be a thing?
Hi, I need to display a bar chart in a dashboard that has one bar for assignee in a project plan. The value of each bar will be the count of late items for each assignee. the only way I can figure to do this is to have an interstitial 'summary' sheet with one row for each assignee, where their name is in column 1, and a…
-
How can a (non licensed) user export selected columns which also shows pictures?
We have users that need to export (or print) a sheet, but only certain columns, which also contain pictures. When exporting to Excel, the user loses pictures. When exporting to PDF, the user can't select the columns they want (they can't hide them either). They can select columns in Gantt view mode, but in that case, the…
-
One Data Set, Multiple Calendars
I have a sheet set up for publishing to Outlook calendar. "PTO Detail" is the primary column and displays on the calendar. I need to create a second calendar with all of the same dates with the second column "PTO Detail Team". What's the best way to go about this? All of the data is input via a form, and both calendars…
-
Filtered Report (Current User) and Direct Access to Sheet
Hi all, I know there are hundreds of different questions around user access, reports, sheets, etc... So I figured just ask this specific question, as I'm sure someone has already solved it. I have a report filtered by current user with their own perspective. Shows data from a source sheet. Works well. Now, my question is,…