Is this scenario possible?
Im trying to find out if the possible scenario is possible in smartsheet:
Im trying to create a time based resource model with input from a questionnaire.
I have the resource requirements in 1 data sheet (ie what resource does it take to complete a list of activities for an item) - Sheet 1 below
i have a 2nd sheet that will tell me how many quarters it takes to complete the activity - Sheet 2 below
im trying to find out if i can combine both sheets to give a scenario where i can map out resource requirement for each quarter?
i tried to use the question number as my unique identified but as it changes with each row, im unable to do a column formula
Help Article Resources
Check out the Formula Handbook template!