-
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…
-
Blueprint Summary Sheet Cell Linking Not Keeping Column Type Property
There is a cell in our intake/project pipeline sheet that is a multi-select drop down. It links to a metadata sheet when a project is provisioned and remains a multi-select drop down. But when it's linked to the summary sheet, it's just a text column with all the checked options typed out. I changed the property of the…
-
Notification and capability to create report for all broken links (Cell Link References)
When links are broken on sheets, we want to be notified and to be able to create report on all sheets in Workspace, so we can fix all broken cell links ASAP. Each team has different schedule sheets and we use cell link from one schedule to another and we depend on the dates on the schedule. Currently there is no…
