-
Index/Match vertical Report
Hello, I have a form for people to submit dinner menus for themselves and for up to 11 guests (but there would be 12 children as the primary contact meal would be a child as well), plus drinks. This forms feed into a sheet that has 74 potential columns of information. As you can imagine, it is too large to really see…
-
Formula to Capture Tasks Starting in the Next 7 Days
I need to capture the count of tasks starting in the next 7 days that are marked as Not Started. Currently anytime I change the Status to Not Started my formula grabs it. So the task will be in the past but the formula is still counting it. Below is the formula I have, I can't get my head around it, any help is welcome.…
-
Help with Join/Collect/Has formula
Hi there, I'm trying to use join collect to gather data that has certain info in the "collect" sheet. I have figured out the formula, but i need to put a space between items and i'm not sure how to do that. the formula i'm using is in blue above this is what it's returning, i would like a space between thing 1 and thing 2
-
Reference a date in a non date column
Hi SS peeps, I am trying to reference a date in a text column by using the date function but it's not working. =SUMIFS({Employee 1}, {Employee Date of Sep}, >[Jan 5th]45, {Title}, {Lead Sider}) I've tried using =SUMIFS({Employee 1}, {Employee Date of Sep}, >Date([Jan 5th]45), {Title}, {Lead Sider}) I'm basically wanting to…
-
Column Names not being recognized in formulas
Hi, I'm running into a problem with the column names not being recognized when typing in a formula. I am trying to count the number of users with access using the "yes" symbol and "Active" status using the following formula: =COUNTIF([User Access]:[User Access], "yes", [Status:Status], "Active") This formula should work…
-
Last Week's Value
Hi All, Does anyone know of a formula that can pull the values from an existing column from the week prior using the cell history or activity log? e.g. I can see the value last week in the cell history but I want to pull it automatically via a column to create a last week vs this week view. My sheet is not date based so I…
-
Call APIs from a formula
Alternate title: Make the most requested calls to an (ideally every) API available as formulas. Often in the community, someone will ask how to do something in a formula. Often, the response is, "You can do that in the API.", or "Just use the API". Here is one of many examples: "How do I look up last week's value of a…
-
How to make Networkdays formula display less than 0 values
Hello, I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd…
-
Clear check-box, without clearing associated Due Date columns
Hi I'm setting up a sheet for reoccurring tasks that have different intervals. I have a task column, interval column, last check, next check and a check- box. When the checkbox is ticked the Last check updates to todays date and this updates the Next check date, calculated from the number of days in the interval column. Is…
-
Automatic RYGB Lights
Hi All, Currently I'm trying to make my RYGB column give the right color light when it meets certain criteria. This must be based on a Start Date column, End Date column and a status column, but I can't seem to figure out a formula that works. So the way it should work is like below: Is there anyone who might know a…