-
links to pivot sheet cells do not hold the link
I have created a pivot sheet. I then from another sheet link a cell to the pivot sheet but the link does not hold. This just started happening with newly created pivot sheets. I have a number of older pivot sheet created and the cell links are fine. I also use pivot cell links in my dashboard metrics, they are now coming…
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
-
CHANGE CELL IF CRITERIA ARE MET
Hello, I have two sheets, the blue one is (Sheet 1) and the yellow one is (Sheet 2). Sheet 1 are data that I got from a form, which includes the date schedule slot and timing. Now, I want in Sheet 2 to show if the date and time is chosen the status in Cabin 1 - Status is not "BOOKED" not Available. How can I do that?
-
How to convert information from a Vertical View to a Horizontal View
Hi! I am looking for some assistance. I have a PTO tracker that colleagues fill in with their Paid Time Off and In Office/Work from Home days. I would like to be able to take that information (that is laid out in a Vertical view and put it in a horizontal view (please see below). I have attempted to link cells, but there…
-
CHECK BOX IF TWO CELLS MET THE CRITERIA
Hello, as you can see, I have a form and if a employee selected a certain date and certain time, what is the formula to tick or check the box on the circled part of the picture. Please share with me the formula. Thank you
-
Merged: Please Remove Cross-Sheet Reference Limit
This discussion has been merged.
-
Multiplication Formula
Hi, I have two columns 'Likelihood' and 'Current Maximum Impact'. All I want to do is multiply them together, can anyone help please? Thanks
-
Incorrect Linked Dates Pulling Though
I'm linking a handful of cells to another spreadsheet, however I noticed the dates that are pulling through are incorrect. I've confirmed I'm pulling up the correct sheet/cells to link too but for some reason the view of the spreadsheet within the "Linking from cell in another sheet" dialog box is reflecting old…
-
I have an excel sheet with at least 4 tabs, and i want to transition that over to Smartsheets
qqqCan anyone assist me in how i can do this, i know smartsheets doesnt include tabs. Below i will give an example. How can i make this reflect in Smartsheets, and as i get new associates, I would need to match them up to a shift? I hope that make sense. any assistance would help, thansk in advance.
-
Cross-Referencing Assigned To Error
I am building out a roll-up sheet and have everything working nicely, with the exception of a single formula. The part of this sheet I'm having trouble with is in the image below. What I am trying to do is have this sheet look at the person named in the column "Primary", then check a couple other sheets to see how many…
