Incorrect Argument Set Error - Intermitent Error

Josh Burack

Hello Community,

I have a portfolio summary sheet with two columns, one configured as a date column, the other as a drop down. Date completed and Status respectively.

I want to count items from these columns that meet a specific date and status criteria and from a portfolio dashboard metrics sheet I have tried two formula combinations and they both work, then they stop working and throw an "incorrect argument error". They appear to work for awhile, then stop. If I open the dashboard metrics sheet the error may disappear and the correct calculations reappear. I read other threads that state the column type must be the same, which doesn't make much sense to me based on the formula definition. The ranges should be the same based on how I slected them via the interface.

I am a formula newbie and I assume there is a trick to solve this issue. Thanks in advance for your assitance.

Formulas I have tried:

=COUNTIFS({Portfolio Summary - Status}, "Complete", {Portfolio Summary Date Completed}, >DATE(2024, 9, 29))

=COUNTIFS({Portfolio Summary - Status}, "Canceled", {Portfolio Summary Date Completed}, >"9/30/24")

Regards,

Josh

Josh Burack

Hi Christian,

After more testing and digging through old posts I found this solution. I will see if the intial error returns, but for now I think I'm set. Thanks for your responses.

=COUNTIFS({Portfolio Summary - Status}, "Complete", {Portfolio Summary Date Completed}, >(DATE(2024, 9, 30)))

ChristianFinke

@Josh Burack

Sometimes dates look right but aren’t recognized correctly. You could try using DATEVALUE to make sure Smartsheet reads it properly. Try the below.

=COUNTIFS({Portfolio Summary - Status}, "Complete", {Portfolio Summary Date Completed}, ">" & DATEVALUE("9/30/2024"))

Hope that helps! Let me know.


Best,

Josh Burack

@ChristianFinke Thank you for the response. I tried your suggestion and received an unparsable error. I also was unable to find DATAVALUE as a function listed in the functiosn list. Am I mising something?

ChristianFinke

Seems like the unparsable error could be due to how Smartsheet interprets date formats. Try this:

=COUNTIFS({Portfolio Summary - Status}, "Complete", {Portfolio Summary Date Completed}, ">" & DATE(2024, 9, 30))

Make sure both columns are consistently formatted as date and dropdown types to avoid parsing issues.

Let me know!

Josh Burack

Hi Christian,

After more testing and digging through old posts I found this solution. I will see if the intial error returns, but for now I think I'm set. Thanks for your responses.

=COUNTIFS({Portfolio Summary - Status}, "Complete", {Portfolio Summary Date Completed}, >(DATE(2024, 9, 30)))