-
Trying to sum columns based on value chosen from linked sheet
Scenario: I have 2 sheets: "AFE" and "Lines". There is a 1-to-many relationship between AFE and Lines (one AFE may have many lines), but I haven't set up parent-child in "Lines" because users will add entries in any order and I can't enforce any kind of sorting or parent-child relationship. In "Lines", there is a linked…
-
Automation not triggering
Hello Community, I am having issues with an automation not firing, not sure what is tripping it up: Also I am unsure if I should see the Update Request icon highlighted in the left margin, when this fires? Of course if I manually click to send an Update Request, it does highlight, but I am trying to set this up so that it…
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
-
Approval request Issue
I have created a form with an approval workflow. When the approval request reaches the approver and they open the approval link, attempting to approve the request results in the following error message: "This link has already been used or was cancelled." Additionally, the approval status is automatically changed to…
-
Date column auto update when changes are made
Hi, I have a sheet that lists a bunch of different sheets and workspace. On that line I have a date column when it was last updated. I was wondering, can I get that date column to auto update when a different sheet has changes made to it? Or somehow create a dashboard or report that mimics this.
-
Board View Group By not working for a drop-down column
We have 3 sheets that we use to track our sprints. Tasks get created on "1 - Backlog Planner" and when the two week sprint starts, automation moves the tasks to another sheet "2 - Current Sprint." When the task is complete, it gets sent to sheet "3 - Completed Sprints." On the completed sprint sheet, the Sprint Name is,…
-
Control Center - Blueprint Permission setting for "Commenter"
We are able to set the sheet level permission "Commenter" for specific blueprint template, but we'd also like to be able to set up "Commenter" permission to certain User Group in Blueprint setting > Permission > Advanced. However, I only see these choices and no Commenter. Can you please add this choice so we don't have to…
-
Move data from one sheet to another without a Data Shuttle
I have my main sheet and I have a second sheet that where a Data Shuttle (staging sheet) is ran and then it filters out duplicate data. Is it possible to move the data from the staging sheet to the sheet in a way that does not require it to be exported to excel? Is a DataTable an option to upload from the staging sheet to…
-
Mobile App
Is anyone else having an issue using the mobile app? I have an employee that is unable to use the iphone app. When logging in, it just keeps going back to the log in screen.
-
Submit a survey with contact as Mandatory field
Dear Community, I have created a form where the contact field is mandatory. If no value is selected in this field, the form correctly shows the error message: “This response is required.” However, if I select a name and then remove it, the field shows a remaining circular icon, and the form gets submitted without any…