formula about remaining days

marcusben · 02/08/19

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 · 02/13/19

Try removing the quotes from around the 1.

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

eric.o · 02/17/19

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 · 09/23/21

thanks so much

formula about remaining days

Comments

Categories