-
If multiple cells are not blank - check the box
I figured the formula to check a box in a column if one other column is not blank, but I can't figure out how to check the box if multiple cells within a range are not blank. I'm using this formula: =ISBLANK([Monday | Start Time]1) = false I have a form that feeds into a sheet that has options for meeting start time,…
-
Count of Completed Tasks by Month across multiple sheets
I am trying to get a count of completed tasks by a team by month across multiple sheets. I've created this formula in the sheet summary: =COUNTIFS(Status:Status, "Complete", [Team Assignment]:[Team Assignment], "Lean"). If I'm trying to get a completed count of tasks for the month of September, how could I get that count?…
-
Struggling with INDEX and MATCH
Hello, I am trying to automate task assignment using the INDEX and MATCH functions. My formula is as: =INDEX({Order Sets Team Contact Roster Assigned To}, MATCH(Role@row, {Order Sets Team Contact Roster Role}, 0)) It seems to work for one role but produces a no match error for the rest of the roles. Please see attached…
-
Slow in loading the conversations/comments
I noticed ever since they updated the conversations/comments. The panel now shows on the right side instead of the usual pop-up. It's been slow to load. I thought it was just my pc that is slow but any pc I use have the same result. My tablet loads faster for these conversations to load.
-
Cross Sheet Reference/ sum values
Looking to VLOOKUP into one data sheet to find - a sales rep name where the sales stage is contracted and sum up the Estimated Value field, which sums up any dollar amount in the (estimated value) field. End result is to show a sales rep and how much they have contracted to close via a dollar amount. My formula example:…
-
Formatting Records for Printing
Where is the best source to learn about formatting records for printing? Do third party apps exist for print formatting? Thanks
-
Clear background / highlighting colors
I added the "Modified" column to a report that feeds my dashboard. Some of the dates are highlighted yellow and some aren't. I checked the source sheets and I don't see any yellow. There was in the past, but it has long been removed and does not show up on any other reports. How do I get rid of the yellow highlighting that…
-
Dates must be formatted correctly
Has anyone else ran into this issue? I have two separate accounts, and I started getting this same error on every form submission for both. This must have started two or three weeks ago.
-
Automated Update Request for Multiple Emails
Hello I set up an automated update request to occur every Monday morning for users in a specified column. This column allows for multiple emails per cell. I am getting reports the emails are not going to all users. It seems like there may be an issue with sending the email to those emails that are second or third in the…
-
Not getting notifications today
Not getting notifications today
