date time help

[SahilArora3139]

I am not getting the correct output can someone tell me where m i going wrong?

ideally :

-where there is no dates in both the column it should give me “PLEASE UPDATE THE DATES” in delayed column

- if closing date is not within 15days of issue date then it should give delayed 

- in my output where it is within 15days or even closed the same date its still showing delayed.

another ask is if someone can help me to add first email tool prior to 5 days if that can be automated ? Email will be send only if its prior 5 days of closing otherwise no email to be sent.

and one email after 15 days only if those records who has crossed 15 days.

please help ?

[Amit_G_Limbasia · Accepted solution]

You can Use two column like this

You can use this :

IF IsNull(DateTimeDiff([Closed],[Issued],'days'))
THEN "PLEASE UPDATE THE DATES"
ELSE(IF DateTimeDiff([Closed],[Issued],'days') <= 15
THEN "With in 15 days"
ELSE "Delayed"
ENDIF)
ENDIF

No of Days Difference

DateTimeDiff([Closed],[Issued],'days')

[binuacs]

@SahilArora3139 

[SahilArora3139]

Thank you so much both of you . It works for me. 
just one more doubt i have 32 entries as of now in my excel sheet but if you can see in the ss i am getting formula after 32 entry as well where the data is not there.

as i cannot delete the columns after 32 in my original excel sheet due to formulas and filter in the column 

is there any way to just get the output till data /entry. (I.e just 32 records ) 

[SahilArora3139]

Also what would be the row rule if i want to send email only if we are about to breach our timeline . 
forexample: close date is at 10 days  and in another 5 days it will breach 

so only if closing date has crossed 10days but before 15 days i want to send email as a top up reminder. Even if closing date is missing and has crossed 10 days but before 15 days.

is it possible ?

[Amit_G_Limbasia]

You can use sample tool for the required solution to remove last 1 row

[Amit_G_Limbasia]

There will be 2 method to get the solution

1 Use Sample tool 

2. Use Filter tool to remove unwanted rows :

[Amit_G_Limbasia]

Hi 

I think you required this type of solution As I am not clear about question still giving possible solution.
Assume might be help so provide Good example so that can be modified accordingly.

Thanks

[SahilArora3139]

To highlight the entries what is wrong in my formula its not working ?

also after highlighting i just need those entries to be sent who are in red. And is not meeting criteria.

[Amit_G_Limbasia]

You can choose column rule Create Insted of row rule.

Please find attached workflow Solution1234 That might be help you!