Date Formulas
Hi all,
Attempting to create due dates for types of tasks within a grid. I will settle for a formula that adds days. But would really love to create automations based on selections made in the types of task column.
Please help😬
Answers
-
The way I would do this is to have three columns in my sheet that are automatically populated:
- 1 - Today's Date when a task is created/requested
- 2 - Number of Working Days until due date (dependent on Task Type)
- 3 - Due Date column with formula
Column 1 would be automatically populated with a Record a Date workflow.
Then Column 2 could be automatically populated through a Change Cell workflow with conditions identifying the correct number of days.
Finally, Column 3 would have a column formula looking at the created date, then adding the number of working days to find the Due Date.
Something like this:
=IFERROR(WORKDAY([Date Submitted]@row, [Working Days]@row), "")
You could skip the second workflow and helper "Working Days" column and write it all into one formula, if you'd prefer. This would be a nested IF statement identifying how many working days you want to add based on the Task Type selection. For example:
=IFERROR(IF([Task Type]@row = "Type 1", WORKDAY([Date Submitted]@row, 1), IF([Task Type]@row = "Type 2", WORKDAY([Date Submitted]@row, 5), IF([Task Type]@row = "Type 3", WORKDAY([Date Submitted]@row, 15)))), "")
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!