Vlookup

Can you have a write up about the data flow from when the user enters the number to your expected end result. It would be nice to have all the logics like this.

image

Sorry But I thought that if this is checked you can make a copy - as I did with yours…

Screenshot 2020-06-04 at 13.07.48

Oh sorry I completely missed the “Copy this app” button. It’s a been a long day for me haha. Let me have a look later tonight.

You are very kind !
Thanks

1 Like

Changes I would made to the app:

  • You stored an image inside a text column, I would delete all those columns and used a “From URL” settings for your image. Since it will always be there, no need to store an additional column in the sheets.

  • For the fee calculation, you don’t need to have to columns to generate the final fee. The problem there was the fixed 6600 as it’s not the same scale as the other numbers. The right setup would be this and it will work.

image

I thought about using a sign function to just have one math column but it doesn’t work with what we currently have. I see you have the same setup for other tabs so hopefully this helps.

Thank you very much
I will do some reworking this morning.
Keep safe.
Mike

1 Like