Formula error when trying to collect the next task due end date.
I am currently using the formula:
=INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1)
to collect the next task due that is not completed for my summary section. I now want to collect the due date for that task. I have a column for "End Date" but not matter what formula I do, I keep receiving invalid column error.
Does anyone know how to fix this? AI is not able to help me with a working formula either.
TIA!
Best Answer
-
That is because you are grabbing a date value and trying to output it in a text column. Converting the date value to a text string by "adding" empty quotes to your existing formula should clear up that particular error.
=current_formula + ""
Answers
-
That is because you are grabbing a date value and trying to output it in a text column. Converting the date value to a text string by "adding" empty quotes to your existing formula should clear up that particular error.
=current_formula + ""
-
@Paul Newcome Thank you!! I've been going crazy trying to figure this out. That was simple.
Help Article Resources
Categories
Check out the Formula Handbook template!