-
Best practice / ideas for dealing with recurring task reminders
Hi, I'm creating a sheet which will contain a list of about 200 tasks. These tasks are all recurring, although not with the same frequencies. Some need to take place annually, some are quarterly, some monthly (and not always on the same day of the month). I need to create some way to track whether tasks have been completed…
-
Need a way to create graph that contains specific parent/child rows
Hey everyone, One of my users has a sheet with a "Task" column that contains multiple parent/child rows. I'm trying to help him find a way to create a chart based on a specific parent/child row, but I'm not entirely sure how to go about this. I was thinking of adding a helper column in, but I'm still lost on how I'd…
-
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…
-
Columns not allowing a sum value
Hi All I am having an issue creating a sum for a column that has $ figures in it. It will just give me the Count. this occurs when I highlight multiple cells, use a summary or when trying to use a rollup sheet. I don't know if this is important, but these column figures are derived from a Data Shuttle workflow that…
-
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!
-
Do all reviewers have to click Approve in review for the Proof Status to change to Approve
I am using automations to ping off the Proof Status Approve to update other status columns in my sheet. I want to verify that if I invite 3 reviewers that all 3 have to click approve before the Proof status updates to Approve or is it only one of the 3.
-
Commenter Permissions Not Working When Sheet is Viewed in WorkApp
I am running into an issue were users that have been granted "Commenter" permissions on one of my sheets are unable to comment or add attachments when viewing the sheet via my WorkApp. When setting the Page Permissions of the WorkApp, only Editor, Viewer, or Hidden are available for selection under each role. My wish is to…
-
No way to paste email addresses into automation?
Does anyone know if there is a way to paste email addresses into the "send to specific people" box in an automation? No matter what I do, it seems pasting into this box is impossible. Instead, I am having to re-type all email addresses into multiple automations, rather than simply pasting them and moving on.
-
Auto-search/highlight
Hello, I'm wondering if there is ANY kind of way that if, when data is entered, there could be some kind of "auto highlight" or notification that there is duplicate data on another line. Here's my scenario: I have multiple users across a few departments. The data is tied to a job # (stays the same) but the job could be…
-
Is there a way to search for new/existing feature requests?
I would like to be able to easily locate existing feature requests that may impact my work and upvote them if they are pertinent/valuable. In addition, I would like to avoid duplication of feature requests as that would dilute the visibility and importance of that request by spreading the votes across multiple items.