-
Using Multiple IFBLANK Checks With IF
Hi, all; I'm trying to use an IF statement to compare multiple dates to a deadline date. This is pretty simple. If any one of the dates in question comes before or on the deadline, the condition is Green. If any of them are past the deadline, the condition is Red. The complication comes in when those cells turn up blank,…
-
Multiple IF functions
Hello, I would like to Nest two If functions in one cell. Below is what I have, but I am receiving an error #unparseable. =IF([ENM INITIATED]@row = 0; "Red"; "Yellow", IF([JOB STATUS]@row = "COMPLETED"; "Green")) I would greatly appreciate your help. Thank you
-
Value if cell contains text
Hello everyone, I'm french so sorry for my english... I want to return the city name if the "Territory" column contains T1 or T2... Knowing that I use a correspondence sheet: T1 = PAU; T2 = Toulouse; .... =IF(ISBLANK(Territoire@row); ""; JOIN(COLLECT({City name Plage 3}; {Correspondance Territoire Plage 4};…
-
Is there a way to calculate the change of role in percentage?
Hi, I have a tracker, whenever the role/status change, it'll copy to this sheet. I'm trying to find a formula to calculate the change % from coordinator to admin, and from admin to the coordinator. Is there a way to do so? TIA!
-
change cell value to include {{column}} does not work same way as email workflow
I am using a Change Cell workflow to use the same feature of the email workflow of embedding {{column}} into the text. The same text that works in email workflow does not work in the change cell. In this example, if the Speed Limit Column is 100 and the Infringe Speed column is 121, the test that is produced should be…
-
Formula to return text rather than a number
Hi there, I have the following columns in use: Plan Expiry date (Date column) Date of Event (Date Column) Status of Plan (Text Column with Formula) I have used the following formula in the 'Status of Plan' column to let me know if a plan had expired when an event occurred. =IF(ISDATE([Plan Expiry Date]@row), [Date of…
-
If/Then date question
Hi All, I'm trying to use the formula below to populate a cell with "late" if the Date Opened +30 days is greater than the Original Due Date. Is this possible? I'm very new to the formula side of SS so any help would be appreciated! Thanks! =IF([Date Opened]1 + 30, >[Original Due Date]@row, "late", "")
-
Need Help with a "SumIfs" Formula
=SUMIFS({Budget}, {Project Type}, {Project Intake Range 1}, =Complete). The "Project Intake Range 1" is a column with "Not Started," "In Progress," "Complete". I want the sum if the "Project Intake Range 1" is "in Progress" or 'Not Started."
-
Help with IF/AND formula for symbols
Hello! I am working on a formula to display red/yellow/green circles for project health, but I want to filter out projects that are closed. I have the formula working but when I try to add the AND part to filter out closed projects, I keep getting errors. Here's what I have: =IF(TODAY() = [Estimated Finish]@row, "Yellow",…
-
Week number based on two columns
HI- I have 3 columns. One is Week Number and two other columns for Parturition Date and Fetal Loss Date. I want to calculate the week number based on if there is a date in parturition date or fetal loss date.