-
Need help with a couple Formulas for On hold and Certain Counts
First formula - In a sheet, in sheet summary I need a formula to count the instances certain Project Channels show up. There are three that will need to be counted. For now let's just call them Channel 1, Channel 2 and Channel 3. They are a dropdown column. Second formula - same thing-same sheet and sheet summary formula.…
-
Help with cross-sheet automation and formulas
I have 2 separate sheets to manage my team's assignments. One is a weekly assignments sheet that pulls from a partner request form and a daily assignment sheet where I manually assign tasks and priority level to each assignment. I want to make it so that when I assign Tier 1 or Tier 2 priority on the 2nd sheet, it…
-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…
-
Copy & Paste Contact Cells between Sheets
Currently only able to copy and paste contact cells on a single sheet.
-
Sheet populating answer not listed in form options
I created a form with several questions. One of them is a required question, with the only two options for answers being "Yes" or "No". Some of the responses I received have a "CA" listed in the field.
-
Symbols
Can I create my own colored symbols and use that as a drop-down instead the predefined symbols available?
-
Presenting attachments on a report widget in a dashboard
I'm looking for a way to present attachments when placing a report widget on a dashboard. It looks as if this column is not presented although it is on the source report. Anyone with a suggestion on how to do that?
-
Can you use the TIME function to calculate the difference i.e. duration between values in 2 columns?
Hello, I've previously used the many pointers and guidance on the forums for coming up with solutions that help calculate time and duration between columns using a range of different helper columns.. I've never used the TIME function before, but I'm hoping I can use this to try and save having to add multiple helper…
-
Merged: Favorite bar organization
This discussion has been merged.
-
Auto-populate form responses from another sheet
Good morning! I currently have an intake form for basic requests for one of my departments. I also have a separate intake form for larger projects that need project management involved. What my ideal situation would be is that when the status on the Basic sheet changes to something like "Needs PM", it would have an…