-
Multiple Forms to One Sheet
Hello! New to SmartSheet. Was wondering if there is any way to do a "Check-in" with multiple forms. For example, 7 unique forms with separate location/date (hidden values?) with one entry of an employee number. Then the sheet would have one row of data with the first column being the employee number and the second column…
-
Lookup multiple values from a dropdown cell and SUM
Hello, I am trying to populate Total Points from Sheet 1 with a formula. I would need to do a multi-value vlookup for my Sheet1[Color] and grab the related points from Sheet2[Color] and SUM them into my Sheet1[Total Points]. Is there a way to do this in Smartsheet? Please see attached images Thanks in advance
-
Merged: Conditional Formatting for Duplicates
This discussion has been merged.
-
conditional totals per column
Hi all Hoping I can find some help on this formula, Trying to figure out how to create sum totals of PO value column at the top of each of the first 3 columns (FERG JOB #, FVLV#, JOB SHOP #) if information is present in those cells. contingent on any of the items in the drop down list from PO/SDR down being selected. Any…
-
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?
-
Suggestions Appreciated
Hi, I am trying to use a form to have people fill out which user groups are allowed to order an item off of a fulfillment site and also ask them to provide the quantity allowed of the item by that user group. What would be the best way to manage the intake of this information and build this into a form? Using conditional…
-
Item Request
Hello, I am creating an item request/reservation form for check out/in of a limited number of headsets, 6 items. I am trying to determine a way for the sheet automation to look at the date a headset is requested and send a confirmation if that date is available for one or a denial if all six are already reserved for that…
-
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
-
IF, AND, OR Functions
So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…
-
Global Update for Conditional Formating?
We work with the control center, and we have 50 plus sheets of a template sheet. (we have approx 10 templates in the template) We need to change the conditional formatting due to a change in our drop-down lists. As of right now, we will have to do it on every sheet. This is tedious and prone to error. With the changing…