Vaibhav_Mohunta - profile

Vaibhav_Mohunta · Oct 14, 2017

Hi, I am trying to write a Nested conditional statement for the following: I have one column named Contract End Date. In one of the other columns, I need text which would say comparing to Today, if number of days before the contract expires is More t...

Vaibhav_Mohunta · Oct 14, 2017

Actually, the code I sent was a simplified one from my actual one which I am wrote by myself. However, the code did not run. The 4 conditions that I need is: If contact end date - Today’s Date < 1, display days If contact end date - Today’s Date < 30...

Vaibhav_Mohunta · Oct 14, 2017

The inverted commas here might seem different in the text I sent, but I used the one you suggested in the code

Vaibhav_Mohunta · Oct 14, 2017

W_Vann_Hall: ’ Hey @W_Vann_Hall Thank you for your reply! I tried your suggestion but it still doesn’t work :worried: IF(DATETIME_DIFF({Contract End Date}, TODAY(), ’days’) >=45,“Greater than 45”, IF(DATETIME_DIFF({Contract End Date}, TODAY(...

User Statistics

User Activity

Problem in my Nested IF-THEN-ELSE statement

Re: Problem in my Nested IF-THEN-ELSE statement

Re: Problem in my Nested IF-THEN-ELSE statement

Re: Problem in my Nested IF-THEN-ELSE statement