Formula for a coming due date in the next 7 days error

I want to add a column in my report with highlights of what projects are past due and will be past due in the next 7 days. I am using the formula below but keep getting "Error: Formula evaluation result in data type is Boolean instead of expected Numeric"

IF($C_FirstGoLiveDate<=TODAY()+Days(7),"Coming Due Date","")

Can I get some guidance on how I can fix this?

Carolina Pedreros December 06, 2022 16:21

Please sign in to leave a comment.

1 comment
Date Votes

I meant I get this Error: Function Days() can be used only in a calculated field

Carolina Pedreros December 06, 2022 17:07 0 votes

Formula for a coming due date in the next 7 days error

1 comment Date Votes

1 comment
Date Votes