-
Data accuracy
I am working on a way to verify if data in all my sheets (about 10) is accurate, however, the trouble I am running into is the data is frequently updated. Is there a way to run a report that is like activity log within each sheet? Thanks, Amy
-
How do I edit which rows are included in an existing (recurring) update request?
I currently have multiple employees who update a lot of projects using forms and recurring weekly update requests. Each project has its own row. Those projects often get reassigned, and new ones are regularly added. I've looked all over the SS community to see if there's a way to edit which rows are included in the…
-
Totaling percentages linked from another sheet
I am simply trying to get an average percentage in a parent row from children rows that are linked in from another sheet. Is the fact they are linked what is causing my error? Currently I'm just using: =AVG(CHILDREN())
-
Radar Charts
Hi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
Conditional Formatting not working
Hello, I've created conditional formatting rules that are not working. They work if I set the rule to "is not equal to" but when I set them to "is equal to" they stop working. The spreadsheet contains "#NO MATCH" cells automatically formatted from another sheet. I want the "#NO MATCH" cells to turn red (not the whole row).…
-
Card view settings
Is there any way I can view the cards showing only the columns with data from the grid view? For example i have about 20 columns on the grid view, and i would like a rule so that when i look in card view only the populated cells appear.
-
Error Message on Sub Tasks
Hi I created a bunch of sub-tasks and when I tag people in the comments and they get the email, when they click on "open in smartsheets", they get this error: "This card is not visible in card view because it is empty" Any idea what is causing this? Thanks!
-
Auto Populate second sheet
Hi, I have a main sheet with a form. As you know, every time a user submits a form, a new row appears. I was wondering if there is any way to have a separate sheet that connects to the main sheet so when a new entry is added through the form on the main sheet, a column is updated on the second sheet reflecting the new…
-
Working with an update request workflow
Hi, I have setup a workflow around an "Update Request" but the one field that I would like them to be able to update does not allow it. I have checked that the field is not locked as well. I have attached a snap shot of both the workflow and how the form comes through. What am I doing wrong?
-
Auto-populating between two sheets
I am currently working on creating some sort of link or equation, that could allow me to create a "directory" sheet where the names in the primary column could be linked to another sheet so that all the names would automatically become options in a drop-down box for another sheet. Is this possible at all, or is this a…
