-
Sheet Summary Metric on Dashboard
Hello, I have a dashboard with a normal metric widget that is linked to sheet summary data from the grid sheet. It works perfectly fine all day, then every morning shows "0" until I open the source sheet, click into the sheet summary tab and save the report. When I go back to the dashboard it is the value it is supposed to…
-
Smartsheet Calendar Failed to Sync to Google Calendar
Hi, We have several instances where we set up the calendar deadlines in Smartsheet but it did not sync with the Google Calendar. Is there a glitch or same issues being encountered this week? We had been doing it before and it sync successfully. We were able to take a screenshots of our tasks so we can show it to our…
-
How to share reports/dashboards with the filter on Current User, without sharing the source sheet?
Hello, I'd like my team members to have access to HR information in a Dashboard, but only info concerning them (current user) should be displayed. I created a sheet, no one but me, has access to, listing all my team members. Then, I created a report and added a filter "Team member - Has any of - Current User". Finally, I…
-
Dashboard not showing for shared users
Hi, I've created a dashboard that displays information unique to each user. The reports included in the dashboard are filtered by Current User, and the Widgets are set to "Their own perspective." I am a licensed user and am the Owner of the dashboard, all of it's reports, and the sheets behind them. This dashboard needs to…
-
Individual Customer Report
Hello, I have a smartsheet form and sheet that I have created reports and dashboards on. The form has many submissions from customers. Many customers have made multiple submissions to the sheet. I would like a report that shows how many individual customers have submitted the form. Is there a way to create this? To note,…
-
Automatic Cell Linking
I already have an automation so that when I update the status of a project to "Shipping", it adds it to our Shipping Tracker and notifies my logistics guy. Is there a way for Smartsheet to link the "Status" cell for that row in the Shipping Tracker to the "Status" cell of our Orders Tracker, so that when the order is…
-
Got few notifications requesting for access to a sheet I don't own.
Today I have received a few notifications requesting for access to a sheet that I don't own. Can you please help clarify why is this happening? And its coming from Automation@app.smartsheet.com
-
Auto Generation of Crossreferenced tables
Topic: New Sheet Row Generation with selected data from a source Sheet with data linked. FYI: I posed this @ Product Ideas too. If you are used to ERP linked data tables you may have explerienced the need to get similar benefit in Smartsheet. We are in the need to generate a new row in a "destination sheet" triggered from…
-
How can I have someone see only their data on a report without access to base sheet?
I would like something where people will fill out a form about their retirement plans and that info goes to a sheet. On that form, before answering the last question, i would like them to click a link and view only their previous entries. I don't want them to see everyone's entries because it's confidential. Here's what…
-
How do i create a report that only pulls in checked boxes from multiple rows?
I am trying to pull in only 3 rows into a report using a checked box feature, but when I create the report, it still pulls in 1000+ rows of information that I do not need to go into a chart on my dashboard. How do I get it to truly only pull in those 3 rows of information so that I can make an easy to read chart on a…