"Arithmetic expression does not have valid input types"

Hello!
I am a new AppSheet user and I’m hoping someone can help me out with my formula

Basically I have an Excel formula that AppSheet couldn’t recognize, so I’m trying to tweak it under App Formula for it to work.

Sample Excel Formula: =IF(ISBLANK(A1),“Pending Submission”,IF(AND(A1-TODAY()<=14,A1-TODAY()>0),CONCAT(“Expiring Very Soon - “,A1-TODAY(),” days”),IF(AND(A1-TODAY()<=60,A1-TODAY()>0),CONCAT(“Expiring Soon - “,A1-TODAY(),” days”),IF(A1-TODAY()<=0,“Expired”,“Valid”))))

In AppSheet, I have the columns [Expiry Date] (with a date column data type) and [Expiry Status] (with a text column data type), so I’m editing the formula under [Expiry Status] and my goal is for the formula to return the values “Pending Submission”, “Expiring Soon - ___ days”, “Expiring Very Soon - ___ days”, “Expired” or “Valid”.

My AppSheet formula is:

IFS(
(ISBLANK([Expiry Date])),
“Pending Submission”,
(AND([Expiry Date] - TODAY() <= 60,[Expiry Date] - TODAY() > 0)),
CONCATENATE(“Expiring Soon - “,[Expiry Date] - TODAY(),” days”),
(AND([Expiry Date] - TODAY() <= 14,[Expiry Date] - TODAY() > 0)),
CONCATENATE(“Expiring Very Soon - “,[Expiry Date] - TODAY(),” days”),
([Expiry Date] - TODAY() <= 0),
“Expired”,“Valid”
)

I’m not entirely sure if I got everything else correct, but the recurring error for the formula above is “Arithmetic expression ‘(([Expiry Date]-TODAY()) <= 60)’ does not have valid input types.”

I’ve tried looking into other articles and questions within the community to look for answers but I haven’t had any luck. However, if anyone has any leads on certain guides or articles that I may have overlooked, please let me know so I can check them out and learn more

Thank you so much!

0 8 2,541
8 REPLIES 8
Top Labels in this Space