Hello Community,
I am attempting to produce an "if/then" statement within a column of my project management smartsheet in order to create an email automation to remind the assigned user to address the aging task. Using the formula, I should be able to create conditional formatting or email automation workflows that address the column(s) populated based on my formula context.
What I am trying to do is define a few things in my formula: 1) if the project is in a state of "in progress" or "not started" (or conversely, if the project is not "complete"), 2) if the "due date" is within 10 days of today's date, and 3) if this statement is not true for the due date, do not populate the field.
I do not want to have to individually set a reminder on each row, I want to be able to drag this formula down through my entire project tracker. I have attempted the following formula that I know from working in excel with conditional formatting but I continue to get the "#INVALID OPERATION" error: =AND([Due Date]3<"",AND([Due Date]3>TODAY(),[Due Date]3<TODAY()+10))
Does anyone know if there is a better way to complete this or what I am doing wrong within my formula?
Thanks,
Matt