About Domearian

Domearian

I have 8 columns in each ROW of data, 6 Simply record Yes/No in each column.At the end of each ROW, I simply want to count the number of Yes in column 7 and number of No in Column 8.Any ideas? Thought it would be simple but am racking my brains....

Domearian

Why have all my Apps stopped creating PDF reports? Is there a service outage?

Domearian

Would it be possible that when an action is run, that action produces a popup that asks for a PIN. If that PIN matches a stored PIN against a user database, the action will run, if not the action will not run?Just thinking about the INPUT() function ...

Domearian

Thought this would be an easy thing to accomplish. It works in other Apps but not in this one.1 action calling 2 further actions.1st Action:2nd:Target (which works fine): IF(LOOKUP(USEREMAIL(), User Administration, Email, Daily ReSync)

Domearian · 04-09-2024

I'm trying to create a slice which will count the number of items in another table where the following conditions apply:Primary table: VRN TableFields: VRNContains 12 VehiclesSecondary Table: Vehicle ChecksFields: VRN & DatetimeOnly 8 Vehicles have h...

Domearian

Perfect, I had thought that an array could have done something but that solution is simple and works! Thank you. 

Domearian

Thanks. Not quite sure how this would work if I change the YES/NO to Completed/Not Completed.So [col1],"Completed","Not Completed"How would that perform a count?

Domearian

You can simply put in a support request - https://support.google.com/appsheetScroll to the bottom:

Domearian

There were no errors and checking the audit logs, all I saw was that the BOTS had completed successfully.

Domearian

Sorry for the late reply. Support have said they have resolved the problem. Hope this helps.

My Stats

Rachelgmoore's Bio

Badges Domearian Earned

Recent Activity

Count Question

PDF Report automations not being created or attached

On Action ask for PIN

Group Actions - Not Running

Slices

Re: Count Question

Re: Count Question

Re: PDF Report automations not being created or attached

Re: PDF Report automations not being created or attached

Re: PDF Report automations not being created or attached

Domearian's Ideas (1)