-
Equation to populate new number
Hello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last column is how much quantity that person claimed (Quantity Claimed). So for example, if…
-
Auto fill cells based on multiple criteria, using Index Match
I'm struggling with the logic here so any help is appreciated. My team manages new hires and we have to rate their performance weekly to report back to the new hires respective manager. Our program is 10 weeks long and to consistently rate them on the same metrics week to week, we created a survey that the trainers would…
-
Error in adding smartsheet as data source in tableau server
Hi All I am trying to publish a sheet to the tableau server so other people in my team can connect using the tableau desktop by logging into our tableau server. I was able to publish the sheet to the server as a data source, but am unable to connect to it again using the tableau desktop The steps I followed are 1.) logged…
-
Formula for RYG status based on Drop down column marked: Complete, In Progress & Not Started
Hi there! I am looking for help creating an IF formula to produce the RYG based on another column that has a dropdown (Complete, In Progress & Not Started). This is what I had: =IF(Status@row = "Completed", "Green", IF(AND(Status@row = "In Progress", "Yellow", IF(AND(Status@row = "Not Started"), "Red"))))
-
Is there a way to RECONNECT a form field to a column in the sheet? Feature Request?
So here's the scenario: You build a form and it creates the sheet automatically. Then, for some reason, you accidentally delete a column in the sheet. The form field still exists, but the column is gone. You recreate that column exactly like it was in the sheet, however, now the two are no longer connected. It'd be great…
-
Copy data from secondary sheets to primary sheet
We are setting up a project approval process. We have a primary “Intake” sheet where initial project data is entered. In many cases, users will be providing project budget and resource information later. We do not want them entering data directly on the sheet so would like to use supplemental forms using a project ID as…
-
Approval Workflow and SUMIF Formula
Hi, I have a form individuals submit when they request tickets for an event. Our sheet manager can either approve or decline the requests. If approved, I have a formula set up that removes the amount of requested tickets from the total. The request entry is copied to a separate sheet that has a calendar of each event along…
-
Is it possible to share a sheet with only certain people in the workspace?
I would like to share a sheet but not with all the users that are in the workspace. Is it possible? Also, I would like to give access to that sheet to other people not in the workspace. Is it possible? Thank you
-
STOCK FOLLOW-UP
Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring something back they also fill in the form and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
