-
Automatically creating a new sheet
We have a form where new employee data is entered, which auto-populates a dashboard smartsheet. What I'd like to do is have a new smartsheet using the data from the new row in the dashboard to create a sheet (from an existing onboarding checklist template) for the new employee to track their progress. Does anyone know how…
-
%Complete Column is not showing % Sign for Parent Row
I have added %Complete Column correctly, however % Sign not being displayed correctly for Parent Row, see screenshot. Total for Parent must be 100% Instead of 1 How to correct it?
-
Unique Children
I am looking for a way to determine when a value in a child row is unqiur from values in other children (in the same parent). EXAMPLE: I have a sheet with four courses. A course may have children if it is offered in more than one modality (e.g., a row if offered om ground and another row if offered online). If it is only…
-
Drag and drop from Google Photos
Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos to my drive. The other option is to save them to my computer. It's cumbersome to do that.
-
Why can't I merge data from 2 sheets onto 1
I'm trying to merge data from 2 sheets onto 1 sheet or even a report. I don't want to have duplicate rows w/ the same primary column though. I want all the data for the same Primary column value on each sheet to be merged into 1 row on the consolidated sheet/report. Why isn't this possible?
-
Counting Unique Values in a Column of another sheet
Hi there, I'm looking to count the number of unique IDs in another sheet I'm referencing (that I cannot edit), and put the count by each ID in another sheet I'm using. I'd appreciate any tips that could help me especially keeping in mind I cannot edit the reference sheet (There are examples similar to this but they require…
-
Can a Report Configuration ... "Include Parent Rows"?
Smartsheet has been a wonderful tool for my team since 2015. A couple things (out of many) I like are the quick sorting options on a sheet and the easy report configuration. With one nusiance exception, and I keep running into this ... On a sheet I can apply a filter and click on a box that will cause the inclusion of the…
-
Join/Collect Criteria
I am using the following formula in Sheet 1 to collect a list of CRNs (course registration numbers) from Sheet 2 (the ranges in the formula reference columns in Sheet 2):: =JOIN(COLLECT({AutomatedCourseCopy-CRN}, {AutomatedCourseCopy-CRN}, <>"", {AutomatedCourseCopy-UseinBCC}, <>"", {AutomatedCourseCopy-College}, CRN1), ",…
-
Need to Resize Window Linked Through Dashboard
I have a shortcuts widget on my dashboard. This contains links to Smartsheet items as well as other useful links. When a user clicks on the link, the linked window appears but it cannot be resized. As an example, I have a link to a project sheet. The sheet comes up using a small portion of the screen, with the Windows…
-
Removing System Generated column (Date) contents
I have completed building and testing my sheet and Dashboards. I now want to remove the System Generated Date for all my Form entries used for testing. If I remove the column and reinsert it, the formulas dont work. Is there a simple way of removing the system generated date data?
