I have 2 spreadsheets:

I am creating a form for work that when my employees fill it out, they have the option to add photos to their report. I’m trying to make it slightly easier by combining so many cells into one and that when they click that group of cells, it will automatically open the insert image over cell function. I don’t really know where to start.

I have 2 tables with the same IDs but different values for some cells. I want to find the different values on the new tab in the following format:
Id, sheet1_field, sheet2_field, sheet1_data, sheet2_data.

I was trying, but can someone help me ?

I have the attached Google Sheet. I can generate the chart on the right fine – which shows floors on the x-axis and time on the y-axis. However, i’m really struggling to swap this around – so that time is on the x-axis and floors on the y-axis. I think the main reason for this is that the hours data is the one changing, not the floors data. How would I go about sorting this?

I need to be able to calculate the number of months someone has been a member, for each year. The trouble I’m having is that I want the same formula for each year, whether it’s the current year, or a past year–this way I can simplify it going forward. I have tried IF, IFS, IF(AND, and I cannot figure it out.

I am trying to build a Google Sheet to track win rate in a game.

I am trying to build a google sheet to track win rate in a game.

I am trying to create a tab that shows delinquent members based on another tab.

Here is my google sheet. On “TO-DO’s by date” tab, in cell E3, I am unable to create the formula so that column G sorts by date. Help??