how can i solve this?
Failed: Action not performed because 26 errors are present. Error: Workflow rule โNew Auditโ action โAction 1โ Attachment template. Expression โ[Cold Room Temp. = Freezer(-12 to -23 ยฐC) / Chiller (2 to 4 ยฐC )]โ is invalid due to: Unable to find column โCold Room Temp. = Freezer(-12 to -23 ยฐC) / Chiller (2 to 4 ยฐC )โ, did you mean โCold Room Temp. = Freezer(-12 to -23 ยฐC) / Chiller (2 to 4 ยฐC )โ?. Error: Workflow rule โNew Auditโ action โAction 1โ Attachment template. Expression โ[Cold Room Temp. = Freezer(-12 to -23 ยฐC) / Chiller (2 to 4 ยฐC )_58]โ is invalid due to: Unable to find column โCold Room Temp. = Freezer(-12 to -23 ยฐC) / Chiller (2 to 4 ยฐC )_58โ, did you mean โCold Room Temp. = Freezer(-12 to -23 ยฐC) / Chiller (2 to 4 ยฐC )โ?. Error: Workflow rule โNew Auditโ action โAction 1โ Attachment template. Expression โ[EXHAUST (noise,cleanliness,hood coverage,duct,leaks,spare belt)]โ is invalid due to: Unable to find column โEXHAUST (noise,cleanliness,hood coverage,duct,leaks,spare belt)โ. Error: Workflow rule โNew Auditโ action โAction 1โ Attachment template. Expression โ[FRESH AIR/Evap Cooler (cleanliness, noise, water supply, components)]โ is invalid due to: Unable to find column โFRESH AIR/Evap Cooler (cleanliness, noise, water supply, components)โ. Error: Workflow rule โNew Auditโ action โAction 1โ Attachment template. Expression โ[BURNERS (flame, knob, orifice, etc.)]โ is invalid due to: Unable to find column โBURNERS (flame, knob, orifice, etc.)โ. Error: Workflow rule โNew Auditโ action โAction 1โ Attachment template. Expression โ[AIR CURTAINS (noise, vibration)]โ is invalid due to: Unable to find column โAIR CURTAINS (noise, vibration)โ. Error: Workflow rule โNew Auditโ action โAction 1โ Attachment template. Expression '[ELECTRICAL (outlets, cords, โฆ
Hi @Jerry
There seems to be a few errors in your template. Could you please post a screen shot of your template.
Hi Jerry, did you already solve your challenge with the template?
Hi Aleksi
Yes I already solve the issue but the problem i encounter right now is that my custom template i made it cannot display the text. Can you help me solve the issue?
Thanks
As far as I see, the excel template is only supporting to generate the tabular data rather than free style layoutโฆ I think that could be a reason.
@Aleksi any idea?
What I have tested with few Excel templates, you can use more than just list of rows. On the other hand we are not so flexible with Excel templates as we are with gDoc templates. Maybe the content on that template is something we donโt support at this moment.
LIttle bit difficult to say what might be the reason why Excel canโt read it. Try to open the Excel file for example from Google Drive as gSheet if that could give any ideas what might be wrong. Alsoโฆ try to remove anything except text, space holders and background colors from the template.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |