Trouble with IF and IFS

[Nantha]

I have a table with a [Status] column and [End Date] column. So i need status to show "Active" if it has not passed [End Date] and show "Expired" if it has passed. Everything is working fine with the expression except for the current day which is Today itself, it shows as "Expired". I have tried using IF and IFS but it reflects the same.  Both expressions as shown;

(IF(TODAY() < [End Date], "Active", "Expired")

IFS(
(TODAY() < [End Date]), "Active",
(TODAY() = [End Date]), "Active",
(TODAY() > [End Date]), "Expired"
)

What am i missing?

[Suvrutt_Gurjar · Accepted solution]

Please try the below expression

IF(TODAY() <= [End Date], "Active", "Expired")

In addition to "<" which is "less than" operator you also need to add "=" "equal to" operator because you want TODAY() also included in "Active" status. 

[Suvrutt_Gurjar · Accepted solution]

Please try the below expression

IF(TODAY() <= [End Date], "Active", "Expired")

In addition to "<" which is "less than" operator you also need to add "=" "equal to" operator because you want TODAY() also included in "Active" status. 

[SkrOYC · Accepted solution]

IF(TODAY() <= [End Date], "Active", "Expired")

[Muzekker_Vatan]

Dear SkrOYC

I have an workflow which sends an email to department. To have that workflow i tried to use two criteria.

Which formula i need to use to be able to send email to right department? Thanks in advance.

If two criteria appears send the mail to XXX@YYY.COM

CONTAINS([Item],"Flight File Pouches"),
[Order Request]=Place the Order

If other two appears send the mail to ZZZ@YYY.COM

NOT(CONTAINS([Item],"Flight File Pouches"),
[Order Request]=Place the Order

[SkrOYC]

IF() - AppSheet Help
IFS() - AppSheet Help

[Nantha]

I did try the expression suggested before giving it a try with IFS as that wasn't working as well.

 IF(TODAY() <= [End Date], "Active", "Expired")

[SkrOYC]

Please share column type and config of both End Date and Status

[Nantha]

End Date is set as a date type column and Status as a enum with "Active and "Expired" values with initial value as "Active".

[Suvrutt_Gurjar]

For existing records, if [Status] is a real column and if you have changed the column's expression after a those rows were saved , you will need to open the row in edit mode and resave for the changed expression to reflect,

[Nantha]

Yup I have an automation which triggers to update the status daily. l even went in to manually effect the column but its just not updating for current day. I tried changing date to tomorrow's date and it changes to the correct status and when i revert back to today, it goes back to expired.

[Nantha]

@Suvrutt_Gurjar & @SkrOYC  I just tried to go into the individual permits and re-save them again and now the status it’s reflecting correctly. Weird cos when the test was done after entering the expression and checking the results, it still displayed as expired. But when I went in to the permit and re-save it, it reflected correctly. I believe I missed out the “=“ in the initial expression to include current day. Thanks for much for your time guys!