-
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?
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Coverpage for Tempaltes
has anyone come up with a creative way to combine a template with a cover letter? So example - we use smartsheet to gather requirements, we want to deliver those requirements to our customer at the end of the project in a polished package. Right now, we use the export to PDF, and add a few notes in the provided comments…
-
Change Order of Sheets in Report
I have two sheets that show data from two different fiscal years: * [FY 2019] Course Development Tracker * [FY 2020] Course Development Tracker I added both of these to the Report Builder, but I want the data in [FY 2020] Course Development Tracker to appear above the data in [FY 2019] Course Development Tracker. I thought…