-
Frequent "Aw Snap" errors in one of our sheets when trying to save
Hey community - we are constantly getting Aw Snap errors when we are trying to update and save one of our sheets. It does have a few conditional formats, but not many and same with automations. It is quite a large sheet with 5563 rows, but way under the maximum of 25,000. It does however have quite a few hierarchy's and is…
-
Sum if checked help
Can someone help me with this formula? I want to sum Net pay if approval is checked I have tried =sumif(payapproval1:payapproval9, 1, netpay1:netpay9) =sumif(payapproval1:payapproval9, =1, netpay1:netpay9) =sumif(payapproval1:payapproval9, "yes" netpay1:netpay9) And a few other variations and I get "unparceable"
-
Report on column that is multi select
I'm trying to build a report that shows the task name and who it is assigned to. The "Assigned to" Column is multi select (as tasks can be assigned to 2 people at a time) . When I try to summarize the report by assigned to I do not even get the option to summarize by assigned to, is that because the column is multi select?
-
How to Group data in a Report by Year
Hello, I have exact finish date for each project in the roadmap. But I would like to create a report that can group these projects together by year only, not by specific date, how can I do that?
-
Permissions - Unlicensed Users
I have several unlicensed users in my team. I've created a template in our shared workspace which I'd like my team members to use. If they are an unlicensed user are they allowed to click "use" on the template? On a similar note, can unlicensed users who are viewers download templates from the Solution Center and edit/use…
-
Dashboard Charts Not Updating Automatically
Hi, Issue: Dashboard charts not updating automatically. Source Sheet, Summary Sheet and Dashboard Setup: Source Sheet: List of tasks, has (amongst other columns) [Frequency], [Status], [Due Date] and [Task Due Today] (Formula to determine if the [Due Date] is today's date). Summary Sheet: Uses the Source Sheet as it's…
-
Columns
Hello, There are columns I deleted that keep reappearing. do you know how or why that is? Shouldn't they be deleted indefinately after I hit delete and not keep reppearing especially when I hit unhide all columns? Also, I've been trying to move columns around on our onboarding tracker. After I hit save, later they end up…
-
Best way to track a challenge
I"m looking for advice and/or samples. I'd like to build sheets, reports, and dashboards to track the daily/weekly tasks for ~25 people. I want to send them the form to check off daily/weekly tasks. Each task will be worth points and I need to build each participant a personal dashboard that shows their progress with…
-
Auto-populate data from one sheet to another
The set-up: We have a Finance sheet that is entirely written over with fresh data once a week by an integration from an external data source. This data is pushed out to various locations based upon look-ups on those destination sheets. Col 1: Client ID Col 2: Client Name Col 3: YTD Revenue Col 4: YTD Profit The problem: I…
-
Logins and password policies
Currently the log in is by user name (e-mail address) and password, which is not optimal. Is there a way (or are there any plans) to use two factor authentication? Also, is it possible to set up password policies to better align with corporate policies? Min number of characters, use of special characters, password expire…