Actual days passed based on % complete and submitted date

Silvia Rangel

Hello,

I am trying to write a formula that gives me the days that have passed between the time the percentage completed has been marked as 100% and the actual end date a task has been marked as complete. The caveat is that l don't know when the percentage complete is going to be marked, and the actual end date is to be manually selected from the calendar....Thanks!

Andrée Starå

Ok.

Happy to help!

✅Remember! 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!

Andrée Starå

Hi,

You’d need to have a manual selection for the date when the % complete was completed or you’d need to use a third-party service like Zapier. Is that an option?

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅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!

Silvia Rangel

@Andrée Starå that's what l thought but wanted to see if there was another option out there. Thanks!

Andrée Starå

Ok.

Happy to help!

✅Remember! 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!