-
Deadline based on Priority dropdown menu
Hello all, I am using SS to process work orders. People fill out a form which has a priority dropdown column with classifications such as urgent, semi urgent, can wait etc... I wanted to see if i could write a formula in the deadline column to calculate a date based on the priority picked. ie- if someone picks urgent, the…
-
COUNTIF
Hi All. I have 2 columns. Cost and install date. Cost have numerical values in it €. and install date has dates in it. I am trying to add up the value of my cost column only if it is after 01/01/2022 in my install date column. Any help would be appreciated.
-
I am trying to write a sumifs formula that sums to create a year to date total
I am writing a sumifs formula that is returning incorrect argument. I want to sum gross commissions based that occur with a date this year and where the agent = the value in the agent column. Current formula =SUMIFS({Gross Commission}, ({Execution Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())), {Agent Name 2}, [Agent…
-
COUNTIFS + CONTAINS + OR Formula
Hello - Looking for some assistance on a cross sheet formula. What I'm trying to calculate is how many Level 2 rows display a specific project manager name from a multi-select column type. There are several rows with more than one name. Additionally, I want the formula to count all projects that have High, Medium, or Low…
-
Forumal Help
Hi Would anyone have a correct formula for =sum of {range}, if {date range}is less than a specific date So I'm adding values in a column, I have another column of dates, I want the formula to add the values only if they are less than 01 01 2022. Anyone?
-
Record a Date when a Text/Number field changes to Any Value
We have a Control Center solution that includes Cell-Links and Cross-Sheet reference columns/cells. We are trying to keep track of the Last Update date for a particular cell. Last Update is a Date column. Days Since Last Update will be a calculation Today() - Last Update. Current Status is the Text/Number field that comes…
-
Index collect from second sheet based on two criteria
After developing the below function, I later realized in addition to Participant@row, it needs a second criteria but I'm unsure how to update. The two criteria's are to match Participant@row with Program Year@row in both sheets before returning Milestones Submitted. Thanks in advance for your help.…
-
If this (Formula) or If that (formula)
I need a column to have more than one formula. For example. I have employees that work in different cities/counties. Based on where they work, there may be a City and County Withholding tax or just A City Withholding tax or just a county withholding tax. A) I have an employee working in Madisonville - there is a city of…
-
Project Plan Formula Not Working.
I am trying to get my "schedule health" column to update based on my dates and or "status" column, I've tried multiple formulas but can't seem to get it right; going at if for two days now. If you're able to help in anyway, I would greatly appreciate the support :). Thank you in advance!! Formula #1 semiworks, yellow, gray…
-
IF Statement For Name Cross Sheet Reference
Hi i am looking to correct this if statement. IF the name in sheet 1 matches the name in sheet two it will check the box. =IF({Mailchimp Database Range 1}, =Name@row, "1")