-
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…
-
REMOVING ALL HIERARCHY FROM SHEET
I'm using a sheet (Grid view) that I initially needed Parent and child rows on, but we have decided we would like a simpler format. I don't want to delete my sheet and start over because I need all the current data as I am still using it. BUT I want to go back thru the sheet and re-format it without the parent/child…
-
Counting unique values over different date ranges
Pretty new to SS, I've only been working with it for less than 2 weeks. I have a sheet with pto requests, I need to count the number of team members that have submitted a quest in a quarter or a year or whatever date range I need. Team members can and have submitted more than 1 request per quarter/year ect. So basically I…
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Drop down list column \ multiple choice
Dear support! Could you please help me to understand if it's possible to use multiple choice in a column with drop down list? I mean that maybe there is a way to create something like that?
