Multiple IF to show different statuses

Closed
annemarie ric - 15 Apr 2016 à 07:29
JasmineJasmineVV Posts 4 Registration date Friday 15 April 2016 Status Member Last seen 15 April 2016 - 15 Apr 2016 à 15:33
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 15 April 2016 Status Member Last seen 15 April 2016
15 Apr 2016 à 15:33
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..