I could really use some help with formulas as part of a RAID log I am pulling together for a project (see below).
I don't know if this is possible but I want the formulas to auto-populate when a new ID (row) is entered on the table. This is because on each new ID e.g. a risk ID I have a 'status' column that either says open or closed depending on the date entered in the Date Closed' column.
If you look at the risk log tab, where the formulas are already dragged down, the status is 'open' even when there is no ID in the row, this is skewing my RAID Log Dashboard saying there are 6 open risks when there would only be 1.
It could be that my formulas are wrong but let me know your thoughts!