-
Nested Ifs
I need and if statement on a metric sheet that counts if 3 criteria are met. If one column = this If another column = that If last column = "No" This is what I have and I though it might work but I get the #UNPARSEABLE error. =COUNTIFS({Range 1}, [Primary Column]3, FIND(AND({Range 3} = [Primary Column]9, {Range 2} "No")))…
-
Resending a Row with attachments
I have an automation set up to send an "update"/"notify" a specific person when a new row is added. I didn't select any advanced options. We didn't want him notified EVERY time a small change is made to a row, but there are times he has updated significant information and he essentially wants to resend that row to himself.…
-
Creating a widget
Hi, I need assistance in creating a widget for a dashboard. So basically I have got a sheet with close to 2000 rows and each of those rows have action owners, due dates, etc. I would like to create a widget that would show when the actions are due and who the action owners are (action owners vs due date). Can anyone…
-
Calendar App - multi-select filter
Hi, can someone point me in the right direction? Can a category filter in a calendar be multi-select, so you can see all selected categories activities in the resulting calendar view? We have a category filter on market priority and would like to be able to offer a multi priority view. If possible, how do we set this up?…
-
Combine "Specific People" and "Contact in a Cell" in the the same approval action
When requesting an approval, I want to be able to send the decision to "contacts in a cell" and cc a "specific person". It appears I can only choose "Specific People" or "Contacts in a Cell" when determining the action from that approval. I have to create a separate workflow based on the population of the approval column.…
-
Calendar View Font Size
Hello - is there a way to change my calendar view font size? I'm just trying to put a basic timeline view of a process but the font is tiny making it challenging to read.
-
Calendar Header
Hello there, I am trying to create a calendar view that shows holidays for 4 different locations around the globe. I've populated the grid with all of the holidays for each location and they are showing just fine on the calendar. But i would like to show regular hours when each location is not on holiday. Ideally i would…
-
COUNTIFS with Cross-sheet references
I'm trying to get a count of rows between two dates AND where we have the status as one of three choices. I've tried using the OR logic embedded in the COUNTIFS formula, but I couldn't get that working. Instead, I created a helper column next to status called 'Concluded' to evaluate whether or not the ticket's current…
-
Need help with a IF(OR) formula
I have the "base" formula correct and working but can't figure out how to string it together (are there best practices in this area?) with a larger formula: This piece works: =IF(OR([Go Live Month]@row = "January", [Go Live Month]@row = "February", [Go Live Month]@row = "March"), "Q120") I want to add conditions for the…
-
SUMIFS with multiple criteria in multiple columns
Hi - I'm trying to create a formula that will sum the amount of hours in one column when it meets a certain criteria (type of hours) from another column, but only if they were accrued after a certain date (a third column). No matter what I try I either get an error. Here is the formula I have so far (which is wrong -…