Using IF Statement & DATE
I'm trying to combine formulas that if a check box is clicked, it returns the number 7 to me or else it runs a formula for subtracting dates from TODAY but unfortunately I keep getting #INVALID DATA TYPE
=IF(OR(COMPLETE@row, "7"), (TODAY()  DATE@row))
Any help would be great appreciated. Thanks.
Best Answer

Assuming COMPLETE is a check box then try
=IF(COMPLETE@row=1,7,TODAY()  DATE@row)
Evaluating a checkbox is 1 if selected, 0 if not. So thus the COMPLETE@row=1 .
If the is true, then return 7, else return the number of days between the date and today.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Answers

Assuming COMPLETE is a check box then try
=IF(COMPLETE@row=1,7,TODAY()  DATE@row)
Evaluating a checkbox is 1 if selected, 0 if not. So thus the COMPLETE@row=1 .
If the is true, then return 7, else return the number of days between the date and today.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!