Post

1 follower Follow
0
Avatar

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

Please sign in to leave a comment.

1 comment

0
Avatar

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

Carolina Pedreros 0 votes
Comment actions Permalink