-
Multi-part formula with multi select field using references issue
Hello- I am trying to write a formula that includes sheet references, and two conditions. I need to count the number of students in each category and how many of those students chose a specific availability time from a multi-select drop-down menu. This is what I came up with but doesn't work. =COUNTIFS({Student Type},…
-
Simple Sum question
This is a simple one but just having a hard time getting it to work. I have multiple clients who purchase a variety of products per invoice. I need a Sum of the Product Type per Client. I've attached an image. For example, I'd like to know Sum of Product 1 for Client 1. In this case the running total =5. I realize I could…
-
Quick CountIfsquery Please
Hello, Hoping somebody can make my life easier please. I'm currently using the following countifs formula: =COUNTIFS({CoCode}, "114", {Status.}, "Not Started") What can I change it to so I don't have to manually enter a new co. code(eg 114) and status (eg Not Started) every time? Imagine there is some way I can just tell…
-
Quotes within a formula for API PUT/POST
How is the data supposed to be formatted when a formula has quotes within it such as =IF(X=1,"One,"") ? I am getting just slashes in place of the quotes when I export a formula using the API, but when I use the same syntax to add/update a column with a formula it doesn't parse correctly. I tried /" and double-quotes.…
-
Formula for Revenue by week and month
Im trying to determine the revenue by week and by month using the completed date field
-
Formula for counting Invites and number of guests associated with that invite
Hello, this is a fairly easy one, but I am stumped so wanted to see if anyone could help. I have a list of people I am inviting to an event. Some invites have 1 total invite and some invites have 2 total invites. I have a column for a count to specify whether it's 1 or 2 invites going out and then a column that says "Yes"…
-
Formula Help - Check the box once per unique ID
Hello - I will try my best to explain my formula question. I am using DataTable to import a few hundred to a few thousand rows of data monthly into a targeted sheet. After 180 days from a specific date column, they roll off the targeted sheet. My goal is to show the Unique Rows like the "delete duplicate" functionality in…
-
Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello, I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they…
-
Is there a formula or other way to have a column display the date that a checkbox was checked?
Is There A Formula or Other Way to have a column display the date that a checkbox was checked? I'm also wondering if the user who checked the box could also be displayed in a column?
-
Metrics NOT updating periodically as expected
Not sure if anyone is experiencing this. I've created a METRICS sheet for every project that sums up counts for Task Health in order to present on Dashboard through Graphs. I'm noticing that theses metrics are NOT automatically updated unless I refresh the page a dozen times OR re-write the exact same formula again. But…
