Welcome!

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

Find more posts tagged with

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Getting the Triggered by at least 5 other workflows but nothing is daisy chained
Hello, I'm seeing this error for the first time as I expand some capability in an existing workflow. Here's how this section with the error works. Scenario: a user puts in a request on the form with a check box indicating they will later upload the required file attachment. Automation sends a request for Approval with…
Re assign task midway thru
I have a task that started in Sept and ends in Feb. I need to assign it to someone else, but do not want to lose the history of the first employee. How do I do this?
Suddenly receiving multiple emails titled "Your Smartsheet Order has been Activated"
Starting a couple of days ago, I started getting 2 or more emails a day about my account being activated. I have a monthly subscription but have never received this type of email from Smartsheet. The email looks legitimate - the sender is "reply_to@Smartsheet .com" - except for maybe the greeting, which is "Dear Customer".…