URGENT - Forms problem, shortcoming

jb@59069 ✭✭✭✭✭✭
edited 12/09/19 in Smartsheet Basics

We use Smartsheet forms to track time and expenses. This morning I have come upon a serious problem for needed updates for one of our clients.

Entering time, employees select from radio buttons, a Phase, Project and Service. We have the following form entries and number of selection options:

Phase - 4 selections

Project - 9 selections

Service - 8 selections

However, not every Project and/or Service needs to be available for each Phase.

I.e., if Phase selection is Focus Groups, then Project should only display 2 of the Projects and only 4 of the Service selections. As is, if Phase is Focus Groups, then Project of Collateral and Service of Video are still displayed and can be selected. This causes massive problems in SUMing hours for each category since someone could select a Project or Service that would not be SUMmed and therefore provide erroneous data totals on our reports.

I assume this capability is NOT available in Smartsheet or is there something I am missing?