-
Import related data into Master registration sheet?
Hi all! I am making a registration form for students who will be attending a summer camp. Because they are minors, we need agreements (I am structuring these in a simple "check the box if you agree to the code of conduct" format ) from both students and parents. The catch is that students and parents may not be filling the…
-
Import to smartsheet is unable to auto-assign tasks - any plans to address this?
Dear Smartsheet, The issue - import of a google/excel sheet containing an "Assigned To" column fails to assign to known smartsheet users any of the tasks listed in the file that was imported with matching user names/email addresses * The specific problem is that even though the name or email address values in the file…
-
How to bid Materials - Construction question needing solution:
Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best solution to take a materials count for my given tasks and then fill in the info I'll…
-
Help with INDEX MATCH with duplicate unique identifiers
Hi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning events all attached to the same cohort name. Records are displayed as: Associate 123456, Cohort 1, Learning Event 1 Associate…
-
Manual cell entry/autofill second cell by referencing another sheet
I have sheet 1 with cell A and cell B, I would like to manually enter cell B and have cell A auto populate by searching/referencing sheet 2. best, Owen
-
Row edit feature and sheets
Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by different areas. One of the areas prefers to work in the edit form to see the information vertically…
-
RYG Ball Automation
Hello, I am trying to automate RYG ball based on Y/N responses to other cells OR I could change the Y/N to also be RYG if that would make this possible. Essentially, my overall goal is to automate the RYG ball based on how 26 other fields are answered -- 13 or less are green = Red 14-19 Green = Yellow 20-26 Green = Green…
-
Control Center Link Woes
TLDR: Needed to migrate project folders to a SysAdmin user after co-worker resigned. Now new projects don't fill into summary sheets properly and project folders are different URLs/Link IDs and can't run Update Reporting on them. --================================================-- Forward: I've opened up a support ticket…
-
Linked cells not showing in dashboard report
I have a dashboard that surfaces a report in which the duration value cells is blank. The report source data is in a row report. The duration value is visible in the row report. The source the duration value is a sheet in which it is also visible. I have refreshed the report but as the duration is automatic I cant do much…
-
Cross-Sheet References with Contacts
I don't know if what I'm trying to do is not possible within the application or if I'm just missing something. I have created a form that the user selects their name from on the dropdown list. On the corresponding sheet, I'd like to populate their email address and office code by using a master contact list in a different…
