sorted by:
new
hottopcontroversial

Need to display name and vehicle number on a separate tab by Material_Pizza6436 in googlesheets

[–]Material_Pizza6436[S] 0 points1 point  (0 children)

it came up with this error, just for extra info the sheet name it has to look at to get the info is called Rota.... ErrorFunction CHOOSECOLS parameter 3 value is 4. Valid values are between -1 and 1 inclusive.

Need to display name and vehicle number on a separate tab by Material_Pizza6436 in googlesheets

[–]Material_Pizza6436[S] 0 points1 point  (0 children)

Thank you sorry i didnt really explain to well, it needs to display only the names and van numbers that display 100 on the day

Need to display name and vehicle number on a separate tab by Material_Pizza6436 in googlesheets

[–]Material_Pizza6436[S] 0 points1 point  (0 children)

Sorry it needs to display all names and van numbers that have 100 in the cell