-
Conditional Index Match with Date => TODAY
Hello! I'm stumped on how to do a conditional index match (or index collect) between two sheets. I'd like to pull in a budget number from another sheet (based off of the project's acronym) if and only if that budget number's end date is in the past. The sheet that I am indexing into will only have the project's acronymโฆ
-
Add IFERROR to formula
Hello, I have a tricky formula question. If I want to add a IFERROR to the following formula where would I go about inserting it? =(((IF(LEFT([End Time (HH:MM)]@row, FIND(":", [End Time (HH:MM)]@row) - 1) = "12", IF(OR(FIND("a", [End Time (HH:MM)]@row) > 0, FIND("p", [End Time (HH:MM)]@row) > 0), 0, 12), VALUE(LEFT([Endโฆ
-
Send Email when any Cell except 1 changes
Hello, Is there a way to send an email when any cell except one changes? I have a field called job status. I need it so that if any field except job status is updated to send an email. What would be the best way to go about this? Thank You, Douglas
-
Sumif Question
Hello, I'd like to sum a set of numbers if a criteria is met from two other columns. Said differently, I want to sum the contents of column A, if column B or column C contain numbers larger than zero. Any help would be greatly appreciated
-
Need to add 6 months and 3 months to a date
I have a date that other will populate, but I need to have two columns that calculated 3 months out from the date and 6 months out. I have tried several formulas on the forum and nothing is working. I am completely stumped. If I was in excel this would have been done in a minute.
-
Apply a formula in a Status column only for the Parent rows.
I've been struggling with this a little bit. I want to pick the status with the dropdown options only for the rows without children and pick the status of the parent rows based on that selection. I have this formula: =IF(Ancestors@row = "True", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started",โฆ
-
Duration column formula: two situations
Hello, I have three date columns involved in the duration: Date Submitted Date Completed For Future Requests My current duration formula only uses the Date Submitted and Date Completed columns: =IF(Status@row <> "Complete", NETWORKDAYS([Date Submitted]@row, TODAY()), NETWORKDAYS([Date Submitted]@row, [Date Completed]@row))โฆ
-
Can you count attachments on a row?
Anyone have insight into how to determine how many attachments there are on a row? dm
-
I want to calculate a Due Date based on a defined Frequency.
Audit frequencies are Annually, Biennially or Triennially. I have used the following formula but I get the #UNPARSEABLE output. =IF([Audit Frequency]@row=Biennially, "[Last Audit Date]@row+730", IF([Audit Frequency]@row=Triennially, "[Last Audit Date]@row+1095", IF([Audit Frequency]@row=Annually, "[Last Auditโฆ
-
Column Formula Question
Is it possible to convert a cell formula to a column formula if it references a different sheet? Here is the formula in question: =VLOOKUP([Project Name]@row, {AM Master Info List Range 2}, 5, false) Where [Project Name] is a column in the current sheet, and {AM Master Info List Range 2} is a range from a different sheet.โฆ