-
Adding Google Looker Studio to Smartsheet
We are now using a new capability in our company called the looker studio to chart some dashboards and it has proved to be excellent. It's just that we don't have a way of incorporating looker into Smartsheet, if that could be done we could have a two way route between the two tools and derive maximum output from our work.
-
Dashboard permissions restricted
I created a dashboard so 'Community Ambassadors' can see who else is registered for the program. It appears that some people are having trouble accessing - we usually solve this by telling them to migrate to our plan but some people are using smartsheet for their day job so cannot migrate. How do we allow people on…
-
can you set up weekly reminders for a date that has gone in the past (off a cell in the sheet)
Im looking to set up a reminder automation that will send out reminders on a weekly basis if tasks are not completed by a certain date. In my sheet there are numerous dates and they are pulled in from formula (dynamic) meaning that i need to pull it off a specific column / cell in the sheet. although the automations allow…
-
Help with Formula
I need Project Health to be based on the count of children's health, but if there is a similar number between the two statuses, select the most critical one. I'm using this formula, and it's given me a red color when the majority are yellow. =IF(COUNTIF(PARENT([Health]@row), "Red") > COUNTIF(PARENT([Health]@row), "Yellow")…
-
Can't create dashboard chart with Report information
I am currently using the Dashboard and Report function but when I tried to created a new chart using the extracted data, this message pops up: • Selected data cannot be charted. Please select a new range. What can I do to understand the data that needs to be revised?
-
User Subscription Model and Dynamic View Permissions
Under the User Subscription Model, can internal collaborators designated as viewers (not members or guests), enter data into a dynamic view? Our group is still on the Legacy Collaborator Model and uses dynamic view to collect data from internal collaborators that share the same domain as our group's plan. These internal…
-
Automations: include attachments
When selecting attachments for an Automation Workflow, we should have the option to include all the attachments in the notification email instead of sending only the last attachment if it was attached after the last save of the sheet.
-
Can free users generate documents with Document Builder?
Hello, I'm a licensed admin and I created a Document Builder template and added the field mapping. I'm wondering if unlicensed users will be able to right click on a row and generate documents using the existing template/mapping I created?
-
Formula Question
I am trying to build a Finance sheet for a project and I want to be able to type in the project code and to pull the info from the Metadata sheet into the finance sheet. I am using a combination of the Project Management Office template set and ones I have created. I have tried to use the existing formula in the Metadata…
-
Removing the "Comments" tab from exported Excel reports
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called…
