-
How do you make IF and IF(AND statements work together
I am trying to populate a cell based on multiple date criteria. I am currently trying to use the below formula but I am getting an unparseable error =IF([Date Submitted]@row > DATE(2024, 9, 30), 25, ""), IF(AND([Date Submitted]@row > DATE(2023, 9, 30), [Date Submitted]@row < DATE(2024, 10, 1)), 24, "")
-
Control Center Error Message
Hi all, I was hoping someone could assist. We were previously able to provision project successfully through control center, however now the automation logs are reporting a failure. I am receiving the following error message on all of the projects I'm attempting to provision: Unable to retrieve Custom fields from Resource…
-
Need help hiding checkboxes
I have a handful of project intake sheets, that ControlCenter looks at to automatically generate project files if approved. We have 2 types of projects that are intermingled on the sheets, and use 2 automations in CC. I'm now running into an issue with some users checking both approval boxes, and CC generates 2 sets of…
-
Sumif question
I'm trying to get a sum of one column based on choices from 2 other columns that have drop down choices. This is the formula that I entered based on the AI chatbot suggestion. It did not work. I am NOT a SS genius. =SUMIF({Quote Status:Quote Status}, "In Progress", "Bid Submitted", "Results Pending", "On Hold" {Bid Success…
-
Dynamic drop-down options based on a selection in another column?
Hello! I have a "Client" drop-down box with 50 options. For simplicity's sake I'm just going to pretend these are values of 1 through 50. Many of the values in the drop-down are only relevant to certain teams based on their geographical location. If possible, I would like to only show the relevant options based on the…
-
Why is December's NETWORKDAYS formula not calculating correctly?
Hi - I have this formula that works perfectly for the year, but when I get to December it is calculating an odd negative number. Can anyone help me understand why and what I need to do to correct it?
-
Sudden Invalid Operation Error
I can see from our audit trail that, on 9/18/24, some of the formulas in our summary sheet suddenly switched from their calculated answers to #INVALIDOPERATION but I can't figure out why. Here's an example: =SUMIF(Status:Status, "Open", [Extended Cost]:[Extended Cost]) This formula seems correct to me… for all rows where…
-
Creating a simple sequence formula for the column
Is there a simple method to create a sequence column in a helper sheet based on a specific number to start the sequence? To give an example, I want to sequence start with the number 25 and increase each row by 1 (ie. 25, 26, 27, etc.), not by any specific project or identifier, simply starting with 25. I thought selecting…
-
Formula to calculate 30 days before
Hi, I have a column with a Partner Due Date (manually entered), and a column with an Internal Due Date (column formula). I would like for the Internal Due Date to be 30 days before the Partner Due Date and am using this formula: =DATE(YEAR([Partner Due Date]@row), MONTH([Partner Due Date]@row) - 1, DAY([Partner Due…
-
Formula help - change date format based on drop-down selection in another column
Hello all! I have a sheet that is being used by people in the US and the UK. Users have requested that the date fields for their projects be formatted according to whichever region they're located in. I have a column named "Region" where they select a drop-down with values of US and UK and then multiple date fields on the…
