Sheets
Discussion List
- Good day everyone, I've seen a lot of posts about changing a symbol based on the date, but none for the other way around. In my use case, I have a Priority symbol that is being filled in on a form. I …
- Hi all! I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to re…
- Hi all, I have created a sheet full of formulas that ALL reference one cell. I would like to lock down everything BUT that one cell, so functionally anyone with access could change the reference cell …
- Hello! I created an intake form that captures data onto a sheet. One of the automations I built out is to create a PDF. However, upon creating - I am having issues with the font size that is being pop…
- Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, includin…
- Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNT…
- I have two sheets. Sheet 1 is essentially a directory. It lists all of the individual contacts that are involved in a project. Some columns in the sheet are are "Name" (Contact List), "Title" (Text), …
How can I return a value in one column from another sheet based on two inconsistent string criteria?
Hi, any help with this will be hugely appreciated. On my master sheet I have a "Task Name" column, an "Audience" column and a "Description" column I want to populate with this formula. On the source s…- Hi all, I have an Excel file in a shared folder on SharePoint that I want to upload to Data Shuttle. For some reason, the table does not want to map. I know I have the correct tab and row numbers sele…
- If a dropdown list can have multiple values in a cell it adds an option to 'Select All'. There should be an option the in properties to hide this where selecting all values makes no sense.