0

I'm trying to create an inspection checklist workflow, using the new MS Lists & MS List Forms. Each check list item is a separate field / column. Each of the check list columns represent a different check (check the oil, check the filter), but they all have the same options (unchecked, checked, fault). The cell should be colour coded in the List view. E.g. "Fault" = red

As there will be a number of these check list items, I'm looking for the best approach to maintain them. I.e. If I change the option text (e.g. "Fault" -> "New Fault") or add a new option to the column "Existing fault" - I'd like all the check list columns relfect this change.

I first looked at using the Choice column type and maybe using Content Types to create a column template, but I don't believe this was possible.

My second approach would be a column using a lookup list, but then I'm having a problem colouring the lookup list options (e.g. "fault" = red cell back ground").

Looking for advice on the best approach to use and maintain the same options in mulitple columns fields.

Thanks in advance, Marcus

Improve this question
Related questions
5497
How do I make a flat list out of a list of lists?
3109
What is the difference between Python's list methods append and extend?
1796
Make a dictionary (dict) from separate lists of keys and values
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.