Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
formula or workaround...
I'm trying to build a sheet to use for our onboarding process.
It would be nice to have on sheet for all positions.
The issue is that all positions do not require the same onboarding activities.
I would like to reference the job title / column and have conditions that would have the sheet only display or include the actions that are relevant to the specific position.
So, at the top, all lines would be used. At the next level, when you enter the position title, only the relevant activity rows, dates, etc. would be visible and active.
I would also like to add conditional formatting that will show workflow and bottlenecks.
Any help would be greatly appreciated.