Hello,
I'm a first time poster looking for a bit of help. I hope the following not a silly request (but concede it might very well be)!
I am managing a spreadsheet with several hundred rows that colleagues will input data on to - please see a smaller scale example below.
I would like to insert a status column (A) that automatically indicates whether a row is 'complete', 'incomplete', or 'not yet reviewed' (or RAG rated) based on information being entered into a number of key columns (M, P, Q).
I have used the =ISBLANK formula in columns (B, C, D and E) to show whether information has been recorded in the cells but would now like to hide these and have one status column.
I'm also limited because the spreadsheet is based and edited in Microsoft Teams.
Is an automatic status indicator possible?
Thank you in advance for your time.
Best,
Drew
I'm a first time poster looking for a bit of help. I hope the following not a silly request (but concede it might very well be)!
I am managing a spreadsheet with several hundred rows that colleagues will input data on to - please see a smaller scale example below.
I would like to insert a status column (A) that automatically indicates whether a row is 'complete', 'incomplete', or 'not yet reviewed' (or RAG rated) based on information being entered into a number of key columns (M, P, Q).
I have used the =ISBLANK formula in columns (B, C, D and E) to show whether information has been recorded in the cells but would now like to hide these and have one status column.
I'm also limited because the spreadsheet is based and edited in Microsoft Teams.
Is an automatic status indicator possible?
Thank you in advance for your time.
Best,
Drew