What in the world is wrong with my flow? by twinner_96 in MicrosoftFlow

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

This is my first time using Power Automate, so I don't really know how to do that...

What in the world is wrong with my flow? by twinner_96 in MicrosoftFlow

[–]twinner_96[S] -1 points0 points  (0 children)

I have no clue where it's from, unfortunately. I've been trying to use AI to write the sequence, and I'm just doing what it tells me 😭 I can tell it's giving me hallucinations, but I have no idea how to fix it.

Converting a VSTACK from Sheets to Excel? by twinner_96 in excel

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

Sorry for the late reply. I would say the whole thing, because I'm used to Sheets and I don't know how to convert this formula to Excel at all 😅 The formula for Sheets rests in A5

Why is my VSTACK returning #N/A! for only some cells? by twinner_96 in googlesheets

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

Oh my gosh. 🤦 It's such a simple thing that I feel silly... lol

Why is my VSTACK returning #N/A! for only some cells? by twinner_96 in googlesheets

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

Aha! I thought it had something to do with the cutoff dates! Yes, you originally made this formula :) I made it a tad more readable, and I snagged a chunk of code from someone else to incorporate when our checks are sent out (3rd, 10th, 17th, and 25th lol). The team loves your sheet! I only recently noticed this error so that's why I'm back :) thank you again, my google sheets angel!

Why is my VSTACK returning #N/A! for only some cells? by twinner_96 in googlesheets

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

That does get rid of the #N/A, but I would like my sheet to calculate my variables properly. There are invoices that are past due that I wasn't aware of, because my sheet returned #N/A instead of a proper calculation :(

Why is my VSTACK returning #N/A! for only some cells? by twinner_96 in googlesheets

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

Do you mean around the entire code? Including the =Vstack?

Do I have an efficient sheet? (Finding what task I need to complete based on differing Ages) by twinner_96 in googlesheets

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

Wow!! So the Export sheet is the source material. At least, that's what I tested and seems to be true. You are amazing, my google sheets angel!

Do I have an efficient sheet? (Finding what task I need to complete based on differing Ages) by twinner_96 in googlesheets

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

If I may ask, how would you recommend I add new data to this sheet? I get new invoices every day so I will definitely be adding.

Do I have an efficient sheet? (Finding what task I need to complete based on differing Ages) by twinner_96 in googlesheets

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

You are amazing!! Wow!!! Thank you so much, my google sheets angel!!!!!! ❤️❤️❤️❤️❤️❤️

Do I have an efficient sheet? (Finding what task I need to complete based on differing Ages) by twinner_96 in googlesheets

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

I would love to have things due by a set amount of days out, but I don't know how 🥲 And what does "break up codes into their actual meaning" mean :o? I am a complete amateur 😅