Referencing checked state of Flag symbol using formula

BMar

I want to use a Flag column to mark high-priority tasks and calculate a reduced lead time.

 

In a Due Date column I use a formula to add 7 days to the Received Date.  I want to change the formula so that it adds only 5 days IF the flag is checked.   I can't seem to find out how to reference the value of the flag cell, though.  Is there a way to do this?

BMar

Should have tried more attempts before posting, but I figured it out.

 

Flag cells return 0 if unchecked (white) and 1 if checked (red).

 

My formula is something like 

 

          =ReceivedDate + IF([Flag] = 0, 7, 5)

Atus Bartal

Great job (in a few minutes)! Thanks for sharing it