-
Restaurar filas perdidas con datos adjuntos
Por error se ejecutó una automatización y se borraron todas las filas de una hoja con muchos archivos adjuntos, necesito recuperar todo y mantener el orden para poder continuar mi trabajo, ¿es esto posible?
-
COUNTIFS - count the number of dates that fall within one month
Hi Community! Hoping you can assist. Can you tell me what is wrong with this formula for counting how many publications that fall within one month? =COUNTIFS( [Publication Date]:[Publication Date], >=EOMONTH(TODAY(), -1) + 1, [Publication Date]:[Publication Date], <=EOMONTH(TODAY(), 0) ) The date in the Publication Date…
-
Formula result is "N/A". Automation does not seem to evaluate it properly
Hi, I have a formula in column C such that: =IF(ISBLANK(column A), column B, column A) column B is also a formula, and the result is sometimes N/A. In the column B formula this result is written as "N/A", so it comes in as text with no leading or trailing spaces. Also, column A, B, and C are all multi-contact columns. When…
-
MAX Formula Cells Updating in Reports
We have two cells with 'planned start' and 'planned end' dates. We also have two cells for 'actual/revised start date' and 'actual/revised end date'. These are designed to allow managers to enter the estimated start/end date of a milestone, and the revised start and end date when things slip. The actual/revised end date…
-
Cross-Sheet Formula Help
I have two sheets: the first sheet is called 'Source Sheet', and the second is called 'Helper Sheet'. I want to use the Helper Sheet to track survey responses that are fed into the Source Sheet. The formula should reference a column in the first sheet named 'Company Email'. If that column is not blank on the Source Sheet,…
-
Formula to pull multiple contacts cells into a single cell
Need a way to concatenate multiple contact list cells into one sell for automation
-
Tracking a 1-day project based on time not date
I am helping manage a 1-day Disaster Recovery exercise and we want to track the tasks by start & end based on time of day. Would also like to auto adjust the times with dependencies - Does anyone know if a template is available of has anyone ever done this before?
-
How to pull the title from a hierarchy at ancestor level 0
Hi All, I just want to pull the title 'BSR Tracker' in column 33 Please note there's another Blue bar in the same tracker i.e. two levels at ancestor = 0 so i just want to pull that title in. currently the formula im using but doesn't seem to be working is: =IF(COUNT(ANCESTORS([Site Name]@row)) = 0, "",…
-
Hammock Task Creation
One of my clients uses Hammock Tasks to represent Project Management and Organizational Change Management in their projects. A Hammock Task is one whose Start and Finish dates are driven by different Milestones. The Start Date would be the date of one Milestone and the Finish Date would be the date of a subsequent…
-
Adding Months to the Same Column
I am trying to setup a sheet that can project dates decades into the future. I want a formula that can look the date in the row above, check to see if it's annual or quarterly, then add the appropriate number of months to each row. While testing the formulas, I keep getting stuck on how to add one year (12 months) to each…