nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Promise Dates

Tony Gentry

Is there a way to formulate a promise date based on current workload (number of request)?

Comments

Brett Evans

The simple answer is yes. As you probably know just add date_value + numeric_value.

The more difficult problem is counting your current workload. I don't know how your sheet is set up, but you probably want to use
COUNT(range_start:range_end)

COUNT(CHILDREN())

To get the numeric_value to add to your current date_value.

A more specific answer would depend on how your spread sheet is set up. Can you provide a link or screenshot?

-Brett