-
Connect a Column to another Column in different grids
Hi, I am using a user form to take in the input on one sheet and as the user inputs, I want one column to replicate (Auto-update) itself in another sheet. How can I make this possible? Regards, Hammad
-
Repeated reminders for no response to update request
Hello, is there a way to set up notification for reminding the update owners to complete their updates until they are done? For example, the due date is 12/10 and the update owner hasn't updated the status. I would like to send them daily reminders until they have changed the due date and/or update the status.
-
Generate Documents - Wrap text
I just started using the Generate Documents function, but immediately something came up for which i can't get my head around it. I have a field wich i fill with a small piece of text. No longer than 2 sentences. The column for that piece of text is set to wrap the text. However, when i generate documents from a fillable…
-
Filter Report by End Dates
I have a report that I am using to 'look ahead' by two weeks. However, I would also like to see any past due dates in case tasks were missed from the previous week. Is there a way to set my filters to see both upcoming dates (by two weeks) and any past due dates? Currently, my filter is set up as status is one of 'in…
-
Calculated Column to the report sheets?
Hi I have a report sheet but that pulls in data from other sheets, I wanted to add another column that does the vlookup and gets the corresponding values from another sheet. But in the report version, the only way I could add a column is by referencing it to other sheets. Is there any way I could add a column? I can create…
-
testing a website: tracking user acceptance testing in a sheet
Hello, I'd like to use sheets to track user acceptance testing. That is, there is a task/item and then the user looks at the task and says it passes or needs remediation. My question is how to do I create a useful dashboard when there is no completed task %? Each user gets their own testing sheet. I can create reports…
-
Summary Sheets Not Updating
Hello. We have several summary sheets that feed reports and dashboard material. All was great until about a month ago when we noticed the summary sheets that contain formulas that reference other active sheets are not updating until you open them. As I mentioned, these feed into reports and dashboard graphs, so when…
-
Dark Theme - or other options - via User Options or Workspace Options
Would it be possible to use some of the CSS to control the color of the (currently hard-coded as the elements are rendered) cells and other backgrounds using the settings for "Personal Colors and Logos.." and the workspace colors and logos dialogs? I have a browser extension for css overrides which I use to reduce opacity…
-
Alert Missing Fields
The alert below is sending without the final three fields and I am unsure why. I have checked the spelling of the field names to ensure there is not a typo inside the brackets. Any thoughts?
-
Too many formula references
I've got a page that's running into an error for having too many cells referenced. The problem is that the page is a list of samples, where samples are grouped into lots (40 samples per lot). I need to do a lot of comparisons within a given lot, which means I'm constantly using formulas that group those lots, such as:…