-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
=IF([End Date]@row,>=TODAY,"Yes", "no")
Trying to tabulate in process Items.. I want it to toggle YES if the end date is past today and No if the end date has not been reached--- from there I want to sum the "Yes" values I have to break this up by quarter so also was going to start with each item by date then add an additional for Quarter so... If Q1 and Date is…
-
Checking a box using an OR statement
Hello, I'm trying to check a box if either of these are true: Data Upload Status = Operational Data Upload Status = 1st Upload Done I'm using this formula but getting an "Incorrect Argument Set" error: =IF(OR([Data Upload Status]@row = "Operational", [Data Upload Status]@row = "1st HydraCor Upload Done", 1)) Thanks for…
-
Date or N/A in a cell
I am trying to figure out a column formula that will auto-populate a cell with either a date or an N/A: N/A, if the [TOTAL BUDGET] cell is under $100,000 or =[Final Report Due]@row + 15 if the [TOTAL BUDGET] cell@row is $100,000 or more (this would be the audit report due date) I tried this but it's not quite working:…
-
Sheet Summary Formula versus Sheet/Report Filtering
Hi all, I've been scratching my head on this for a while and I can't resolve why the filtering I do on a sheet/report is not matching my formula on a sheet (upon which the report is based on). Here it goes: I have an intake sheet for my projects that when a PM creates a project via Control Centre, it spits out the expected…
-
Using COUNTIF and OR Function
i am currently using the following formula to control a parent reporting "Ready" or "Not Ready": =IF(COUNT(CHILDREN()) = COUNTIF(CHILDREN(), "COMPLETE"), "COMPLETE", "Not Ready") I would like to add an "OR" function to this to allow both "COMPLETE" and "NOT REQUIRED" to trigger the parent "Ready". Can you help me…
-
Max(Collect formula
I'm trying to pull in the most recent date of a file, and it looks like =Max(Collect is the way to do it, but I'm having trouble with getting the formula to work. Currently, I have =MAX(COLLECT({Date of Recent Update}, {Parent Folder}, [Delivery Path]@row)) where Parent Folder and Delivery Path would be the reference to…
-
Create Percentage Based off # of Checkboxes Checked
1) Creating a percentage to tally how much out of each section is checked completed. 2) Then also need to setup a formula to do the same for the overall sheet including all subheaders. This is the formula I have so far for the individual subheader sections. But I keep getting Invalid Operation errors. Not sure what I'm…
-
Status Symbols from Multiple Date Columns
I'm looking to have a health status (green, yellow, red) populate by checking multiple columns with differing expiration dates. I'm trying to come up with a formula that will return the following status': IF[Orientation Date] is in the past and [First Aid Ex Date], [OTS Exp Date], [BBP Exp Date] are at all least 30 days in…
-
IF Function not returning as expected
Hello I have an IF function I am trying to run that evaluates a cell, and then returns one of two indexing formula results I have verified that each indexing function and the If function itself with different results all seem to work. But when I plug them together, my IF function stops evaluating "3100" properly, or it…
