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

baalzimon asked Jun 11

moira_desu asked Jun 4

jcarminio asked May 19

amandabee asked May 16

amandabee answered May 15

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

baalzimon asked Jun 11

moira_desu asked Jun 4

jcarminio asked May 19

amandabee asked May 16

amandabee answered May 15

Tags

Connect