-
Allow Freeze Columns in Dynamic View & better visibility to the row you're selected
When working with a dynamic view that has conditionally formatted rows, it becomes difficult to see what row you are clicked on when making updates in the details pane. Also not being able to freeze columns is a major disadvantage.
-
Automation Workflow Triggers - Delayed response
I'm not sure if this is normal, but I have a simple automation to update a cell value when another cell value is changed. The trigger is working and the update works, but there is a significant delay in the response time. Over a minute from the time I make the change until the automatic update is performed on the sheet.…
-
Proper way to use both AND and OR in a CountIFS formulat
-
Formula Errors with Index match
I'm trying to get an index formula to look up the employee ID and return the project they are assigned to on another sheet. The issue is that if the ID is blank, its returning the first project in the list with no ID #. I thought the IFERROR would take care of that but it isn't. Any suggestions? =IFERROR(INDEX({Proj_Name},…
-
Get login activity for external users —equivalent to the User Type Report
What's the appropriate method I can use to return the equivalent to the User Type Report that one downloads in User Management? Basically what I want to retrieve is the following info: Email, Highest permission given on assets, Last activity, and Number of asset views by user. With the List Users method I can return the…
-
Proofs available as file attachments in Dynamic View
We would like for Proofs to be available within Dynamic View
-
IF formula error
Hi, I have a big dropdown menu for "estimate status" and I need the column next to it to give me the person who is assigned depending on he status" =IF([Estimate Status]@row = "Case Needed", "Riley", IF([Estimate Status]@row = "Design Underway", "Lester", IF([Estimate Status]@row = "Design Underway - Previously Proposed",…
-
Create a summary of errors within a row
Hello, I have a row of that contains information about projects (like project name, project owner, start and finish date) and I want to create an easy way to see the deficiencies in a row. For examples, if a start date is blank. I've been trying to figure out a way to have a multi-select dropdown show each possible error…
-
Formatting and Status Checks
Hi, I am trying to find the simplest way to format and complete a "status check" on each row based on the field "Process Type". So for each process type, I have identified a list of fields that are required to be filled in. I can use conditional formatting to make each of those "highlight" when empty, that's simple. What I…
-
Search multiple sheets to return data to consolidated sheet
I am utilizing multiple worksheets (one for each year) but have one sheet that has some consolidated information, and I would like for it to be able to pull from the appropriate year sheet. =IFERROR(INDEX(COLLECT({Quote Log 2024 Quote Status}, {Quote Log 2024 Quote #}, @cell = [Quote Number]@row), 1), "") I would like for…