formula about remaining days

marcusben

hello,

I want to use below formula for remaining days;

=IF([Tamamlanma %]1 = "1", "T", [Hedef Tamamlanma Tarihi]1 - TODAY())

 

but when i use it , i cant see result ...

note: now i am using try version... so ı cant maybe is it possible?

 

thanks

Paul Newcome

Try removing the quotes from around the 1.

 

=IF([Tamamlanma %]1 = 1, "T", [Hedef Tamamlanma Tarihi]1 - TODAY())

eric.o

Hello,

 

Paul is correct, removing the "" around the 1 may help resolve the issue. You also may want to confirm the column type the formula is within is a text column and the "Hedef Tamamlanma Tarihi" column is a Date column. 

 

Cheers, 

Eric  

Smartsheet Support

marcusben

thanks so much