Sign in to join the conversation:
I am just trying to add the blue cell and the pink cell. Anyone able to help?
Hi there,
I don't know the exact column names because I don't see a screenshot... but you should be able to do this...
=[Pink Cell Column Name]rownumber + [Blue Cell Column Name]rownumber
For example... if the pink cell column was titled PinkSeats and the row was 24 and the blue was BlueSeats and the row number was 8 then the formula would look like this.
=[PinkSeats]24 + [BlueSeats]8
Would add those two cells together.
Super thank you.
You're welcome!
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…
