Merge Condition Issue

108 views
Skip to first unread message

Christopher Biggs

unread,
Mar 3, 2025, 2:23:54 PM3/3/25
to NV Autocrat Add-on
I have updated autocrat and for some reason a merge condition that indicates only to run when the "Send?" column equals "Yes" is not not showing anything previews available even when multiple columns indicate "Yes." Is this an error in the new version? Thank you. 

Joseph Schmidt

unread,
Mar 3, 2025, 4:16:44 PM3/3/25
to nv-autocr...@googlegroups.com
Do you mean multiple rows?

Autocrat will not process a row with anything in the status column.  Is that the problem?



On Mon, Mar 3, 2025 at 2:23 PM 'Christopher Biggs' via NV Autocrat Add-on <nv-autocr...@googlegroups.com> wrote:
I have updated autocrat and for some reason a merge condition that indicates only to run when the "Send?" column equals "Yes" is not not showing anything previews available even when multiple columns indicate "Yes." Is this an error in the new version? Thank you. 

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/b56d5c0c-9a87-48fb-a9a3-16532c502aa7n%40googlegroups.com.

Jessica Gestwicki

unread,
May 28, 2025, 11:59:47 AM5/28/25
to NV Autocrat Add-on
I am having the same experience -- no merge conditions are working. Whether I set the merge condition value to the cell contents or specify that it run on any NULL or NOT NULL contents, the merge fails every time.
The new job I created today does not work; old jobs that previously worked do not.
Nothing is in the status column for any rows.

Jessica Gestwicki

unread,
May 28, 2025, 11:59:59 AM5/28/25
to NV Autocrat Add-on
I did discover something since I gave up and posted here.

I set a formula to put "y" in a column "cash" if column "Bookkeeping" equaled "cash", but of course the formula made each row NOT NULL. I thought I could get around this by copying and pasting values only, but it turns out that I had to delete the contents of each supposedly-NULL cell individually.

Still, I haven't any luck merging a column based on a specific value -- I should have been able to parse each row where "Bookkeeping" equaled "cash" without this klunky workaround.
On Monday, March 3, 2025 at 4:16:44 PM UTC-5 Joseph Schmidt wrote:

Joseph Schmidt

unread,
May 28, 2025, 12:07:46 PM5/28/25
to nv-autocr...@googlegroups.com
Can you share a copy of the spreadsheet, and template with me at GLUA.Joe @ Gmail.com.

Autocrat is looking for an exact match.  If there is a space as in "cash ", I don't think it will work.

Because of the way numbers are stored, I can see the need for a formula to create a text value.


To view this discussion visit https://groups.google.com/d/msgid/nv-autocrat-add-on/848f9ddf-9bdb-4b33-8885-a7c7be15eb78n%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages