-
Calculating Remaining Eligible Vacation Days with already Approved / Declined Requests
Hi there, Is it possible to do the following in SS? I'm currently working with two sheets, Leave Requests and Employee Directory. * My Leave Requests is the main sheet I'm working with - a running list of all leave requests from our staff * My Employee Directory is a reference sheet for the number of annual vacation days…
-
Hidden Column Data Viewable in Export
Hello, I have a table where I hid Column C that has confidential information. Viewers and Editors cannot Unhide the columns of Confidential Information. This is amazing. However, here's the kicker... If the viewer/editor Exports the smartsheet they can unhide the hidden columns. How can I stop that to keep these…
-
Automatic Form Repsonse
Hello, I have a form in which staff submit their mileage journeys. In the smartsheet (not the form) I then have a column which totals all their journey miles to give the total mileage completed and the amount to be paid to them which the person submitting doesn't get to see. Is it possible to set the sheet up so that an…
-
Countif children row with reference another sheet
I want to count the children rows in another sheet that contain a certain value, my attempt gets an #UNPARSEABLE =COUNTIF(CHILDREN(){Lease Tracker 2018 Manager},="CORNELIUS")) Any thoughts? THANKS!
-
Linking cells to a child cell in another worksheet
I have created a Summary Worksheet to capture high-level milestones from a collection of project plans. The way I set up the summary tracker is to create a parent-child relationship under each project and am trying to link the start and end dates from the original project plan to this summary worksheet. The challenge I am…
-
Formula help
Hello, I have been trying to work this one out. Attached is a picture of the column that i wish to tally. This column is a checkbox column and there are multiple parent lines (these are the colours lines) The top line is the grandparent line the white rows are the children. So what you see is each children row has some…
-
SUM more results from more IF conditions
Hi All, image different questions (1 for each column) with 3 possible drop-down answers (Yes, Maybe, Not). Every combination question/answer generate a different score. Ex: Question 1 * Y - 3 points * M - 5 points * N - 8 points I need to have in a single cell the sum of the score of a gruop of question. Have you any tips…
-
# of Attachments in a Cell
I would love to log the amount of attachments a line has in a cell. IE 3 attachments, I would like to have one of the cells read "3" so we can at a glance see how much documentation is added to the line. Does anyone know if this is possible with Smartsheet?
-
Credentialing Tracking Template
Hello, I am looking to set up a credentialing tracking template. I would like to track the credentialing process including but not limited to documents submitted/pending, approvals, etc. I'm curious, does anyone out there have any examples of such templates? Any ideas are much appreciated. Thank you!
-
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…