-
Numerous issues in last few days
Have others been experiencing any unusual activity in the past few days? I have been having a number of issues that appear to be related to permissions and reports e.g. A report we use daily suddenly showed a permission error for one of the users in the team although their permissions have not changed and they are owner of…
-
RYG Automation using Drop Down lists
Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the drop down, I want the RYG column to show Red. If someone chooses 'Interviews and…
-
Return entire row when value is matched in another sheet
I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). What I would like is to have have any rows in the source sheet which match a specific…
-
Sharing Sheets to Multiple Workspaces
I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate workspaces that would allow me to see overviews for ALL projects, all pulling from the same sheets.
-
Sorting a sheet when opened
Wondering if there is a way to sort rows of a sheet on open. Otherwise you have to set this up manually each time. If this is a smart sheet you would think it would be able to do this.
-
Cross-Sheet Formulas
Hi! I am trying to reference another sheet in a SUMIF. But I get "#UNPARSEABLE" I want to sum contribution $ in Column 2 if the vendor name is 9X. This info is in Sheet2. I am referencing it in Sheet1 Here is the formula : =SUMIF({VEND},"=9X",[{DSU}]) I have tried the formula =SUMIF({VEND},"9X",[{DSU}]) And…
-
Paste raw data into Filters
I love the Filter for "Show rows that match" is one of "select values". I however would love to be able to paste from NotePad, Excel, an email, etc a list of values separated by line or comma (IE: 5045,5046,5097,6014,5058) to automatically have that select instead of having to scroll down to select the 50 lines I want…
-
Custom column changes places when copy between sheets
Just wanted to point out that when I did a <Copy to Another Sheet> I discovered that a custom column placed in the first sheet did get copied but it was placed at the end of all pre-defined columns in the second sheet. A bit confusing since that place was out of view in the Gannt-view...
-
Embed certain columns on another page?
Is there a way to publish and embed a sheet's data onto another page with only certain columns? Example - Sheet has Sprint milestones and Notes column with Gannt view. We are using Confluence/Jira tool to document and report statuses, would like to embed this gannt view but exclude the column with notes so it's a cleaner…
-
Completed Row Drops To Bottom
Hi everyone, While at Engage18, I heard there would be a way to have a row drop to the bottom of the sheet, once completed. Does anyone know if it's at all possible right now, or is this something they are still working on?