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 ?
Solved! Go to 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')
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 )
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 ?
You can use sample tool for the required solution to remove last 1 row
There will be 2 method to get the solution
1 Use Sample tool
2. Use Filter tool to remove unwanted rows :
You can choose column rule Create Insted of row rule.
Please find attached workflow Solution1234 That might be help you!