nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Link to Download Attachment Missing
Hi, I have automations in place to generate various documents, based on the form completed. Once the document is generated, the user WOULD receive an email that included a message I create and then a link (at the very bottom) for the recipient to click on to download the generated document. Now, I still get the email but…
Safe Sharing Audit
Is anyone aware of a method to inspect the login history of individuals added to your Safe Sharing Exempt List? We feel it would be wise to audit this periodically and then disavow anyone who has not logged in after x months
Solve for Sending rows without Linking to Sheet
Hi! We have a project list that goes through our SteerCo for approvals on Wednesdays. I have an automation that sends all approval decisions from the meeting to the stakeholders following the meeting (set an hour after meeting conclusion). We have it set up so that only a couple admins can see the main sheet, all other…