Hello;
I am working on a status report and looking to populate date if only applicable to certain condition. For example, If a project is within a the 5 day SLA then it would populate in the 5 day SLA cell (H4) if its a 10 day SLA them # populates in (J4) cell. The condition can reference the (G4) cell.
5 or 10 Day SLA Cells.jpg
It would also be useful if the field would populate "N/A" for cells (I4) and (K4) to let the user know that corresponding SLA timeline is NOT applicable.
Much appreciated
Michael
File is attached too! thanks
Bookmarks