Using Decision Symbols Yes, Hold, No

Amy Smith

I am trying to write a formula to show the 'Hold' symbol three days before 'Date Needed By', and 'No' symbol if one day past 'Date Needed By'.

(Date Needed By) is a column on my sheet. The Decision Symbols are Hold (yellow triangle), No (Stop Sign)

If 'Date Needed By' is within 3 days show "Hold", if one day past 'Date Needed By' show "No", Otherwise show no symbol. Is it possible to do this using decision symbols? I'm new with formula's and there seems to be many ways to write formulas. My symbols are appearing but the logic is wrong. Can someone please assist?

Paul Newcome

Try something like this...

=IF([Date Needed By]@row = TODAY(), "Yes", IF([Date Needed By]@row < TODAY(), "No", IF([Date Needed By]@row <= TODAY(3), "Hold")))

Paul Newcome

My apologies. I assumed that when you said

..."and 'No' symbol if one day past 'Date Needed By'."

That you meant anything past due instead of taking it to be literally only equal to one day past due. Here is the fix for that...

=IF([Date Needed By]@row = TODAY(), "Yes", IF([Date Needed By]@row = TODAY(-1), "No", IF([Date Needed By]@row <= TODAY(3), "Hold")))

For the portion about within the next three days we can try a different approach...

=IF([Date Needed By]@row = TODAY(), "Yes", IF([Date Needed By]@row = TODAY(-1), "No", IF(AND([Date Needed By]@row <= TODAY(3), [Date Needed By]@row > TODAY()), "Hold")))

Paul Newcome

Try something like this...

=IF([Date Needed By]@row = TODAY(), "Yes", IF([Date Needed By]@row < TODAY(), "No", IF([Date Needed By]@row <= TODAY(3), "Hold")))

Amy Smith

Thank you Paul! How would I indicate to leave the cell blank if it is not three days before due date, or past due?

Paul Newcome

My apologies. I assumed that when you said

..."and 'No' symbol if one day past 'Date Needed By'."

That you meant anything past due instead of taking it to be literally only equal to one day past due. Here is the fix for that...

=IF([Date Needed By]@row = TODAY(), "Yes", IF([Date Needed By]@row = TODAY(-1), "No", IF([Date Needed By]@row <= TODAY(3), "Hold")))

For the portion about within the next three days we can try a different approach...

=IF([Date Needed By]@row = TODAY(), "Yes", IF([Date Needed By]@row = TODAY(-1), "No", IF(AND([Date Needed By]@row <= TODAY(3), [Date Needed By]@row > TODAY()), "Hold")))

Amy Smith

Thank you, I appreciate your assistance.

Paul Newcome

Happy to help. 👍️