Is there a way to have a formula calculate dates for a work load?

Dan McGrandy

Looking to have a formula to create a date work load for an individual. Example if there is a spot to enter a part qty on an engineering change (i.e. - 210 parts entered into a column or cell) and using predecessors for a start date from a previous cell - the qty of parts dictates the processing days - example - if 50 parts can be processed by an individual to write bending programs - they would get 5 days to process their work load on that change

Stefan

Hi Dan,

you could use something like this:

=WORKDAY(STARTDATE1; ROUND(qty1/ 50))

STARTDATE1 = your column with the start date (e.g. defined via predecessor)

QTY = your column with the parts number

https://help.smartsheet.com/de/function/workday?dlm=111&frame=0&nav=1

https://help.smartsheet.com/de/function/round?dlm=111&frame=0&nav=1

Hope this helps

Stefan