# Importing equation from Excel

edited 07/05/20

I imported a sheet with the below equation from Excel. However,it comes back with #UNPARSEABLE and i'm not sure where it's going wrong on Smartsheet, any help or advice would be highly appreciated.

=COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,">="&TODAY()-30)+COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,"Weekly")+COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,"Daily")+COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,"Biweekly")+COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,"Monthly")

Thanks and Rgds

Hani

• Genavieve, thank you very much for your support! it worked!

You are correct, the column [Last FSR Airplane Visit Date] is a date/text column. That is intended.

I have applied the Today format you recommended on other equations and its worked apart from the below. Can you please take a look at the below and let me know why it is not working? Is it because of the combined text/date column that the function is looking for?

=COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,=>TODAY(-30))+COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,"Weekly")+COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,"Daily")+COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,"Biweekly")+COUNTIFS([Visit Interval]1:[Visit Interval]387,"",[Last FSR Airplane Visit Date]1:[Last FSR Airplane Visit Date]387,"Monthly")