Can anyone tell me why this formula returns: Too few arguments in function if

Question

if(prop("Retention") == "<50%", dateAdd(prop("Last Revision"), 1, "days"), if(prop("Retention") == "70%", dateAdd( prop("Last Revision"), 7, "days", if prop("Retention") == "90%", dateAdd(prop(Last Revision), 14, "days"), dateAdd(prop("Last Revision "), 0, "days"))))

Answer 1 · 2022-12-28T23:59:45+0000

2votes

adam Points1460

this line is missing a ')'

if(prop("Retention") == "70%", dateAdd( prop("Last Revision"), 7, "days", if

should be this:

if(prop("Retention") == "70%", dateAdd(prop("Last Revision"), 7, "days"), if

answered Dec 28, 2022 by adam (1.5k points)

Can anyone tell me why this formula returns: Too few arguments in function if

Please log in or register to add a comment.

1 Answer

Please log in or register to add a comment.

Please log in or register to answer this question.

Recent Activities

jcarminio asked May 19

amandabee asked May 16

amandabee answered May 15

polle answered May 14

amandabee answered May 13

Tags

Can anyone tell me why this formula returns: Too few arguments in function if

Please log in or register to add a comment.

1 Answer

Please log in or register to add a comment.

Please log in or register to answer this question.

Related questions

Without Answer

Recent Activities

jcarminio asked May 19

amandabee asked May 16

amandabee answered May 15

polle answered May 14

amandabee answered May 13

Tags

Connect