-
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…
-
Can you create a master project plan with rollup plans below?
I need to create multiple project plans with one resource in common so I want to make tasks between the plans dependent on eachother so that the engineer doesn't have overlapping work and if one task is delayed it will impact the other projects. Is this possible? I don't want to run a report because I won't be able to add…
-
Can you create a Sheet Rollup of all open actions from each project owners sheets?
What about a sheet to roll up all open tasks of each project owners sheets so a managed worked flow to request updates would include all updates needed for all the project owners sheet actions? This way they are not getting a lot of separate emails for updates on each sheet.
-
Changing Drop Down Value Based On Current Date?
I am trying to change the drop down value on my Health column based on the current date. Is this possible? ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.
-
Is there anyway to set a cell to be both inbound and outbound?
Is there any option to set a cell to be both inbound and outbound so that regardless of which sheet I update the cell, the two sheets will be updated? Thanks in advance.
-
Select a user defined value for a default in a form
Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will go into several boxes. is there a way to have a form look at a value the user maintained in a table, (box number), then have…
