I meant I get this Error: Function Days() can be used only in a calculated field
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?
Please sign in to leave a comment.