Multiple IF to show different statuses

Closed
annemarie ric - Apr 15, 2016 at 07:29 AM
JasmineJasmineVV Posts 4 Registration date Friday April 15, 2016 Status Member Last seen April 15, 2016 - Apr 15, 2016 at 03:33 PM
Hello, I am trying to have different status in my reports depending on the dates in different cells
H START
I ACTUAL START
J DUE
K DATE COMPLETED
L OVERDUE WEEKS
M STATUS

I have the following and it works (this is in M)
=IF(K3="",IF(L3>0.15,"Overdue","Open"),IF(L3>0.15,"Closed Late","Closed"))
overdue
Closed Late
Open
Close

I want to add to M if there is a date in I (actual strat) to show "In Progress" if the start date is the week to show "start this week" and if the due this week to show "due this week" But i am not sure what add

Annemarie

1 response

JasmineJasmineVV Posts 4 Registration date Friday April 15, 2016 Status Member Last seen April 15, 2016
Apr 15, 2016 at 03:33 PM
I looked through the formulas and had this question: is there a formula that allows me to update cells with lookup formula, based on shared lookup values between the sheet I'm working on and another Smartsheet sheet or external spreadsheet? or is the correct thing to do: export sheet, perform vlookup, upload sheet..
0