Sign in to join the conversation:
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
Try removing the quotes from around the 1.
=IF([Tamamlanma %]1 = 1, "T", [Hedef Tamamlanma Tarihi]1 - TODAY())
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
thanks so much
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
