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

How do you hide all but 2 fields in a form
I have set up a form with conditional logic to display the fields I want to display upon select criteria and that is working. However, at the beginning of the form I only want 2 fields to display and the rest to be hidden. Based on the below logic I thought the form would only show the first 2 fields selected but that is…
Question about what Data Shuttle Run Options
Hello, I am not sure i understand what the scheduler means in the data shuttle I have set up. Does the below mean that my scheduler will run every hour from 5 am to 8 pm each day? I need it to update often but not sure if this will do it or not. Thank you to those that are smarter than me :-)
Request Snapshot not received. I am the sheet owner. Not on spam/junk.
I have requested for a snapshot, but I have not received the email yet. Any idea why and what do I need to do?