-
identify sheets that an email address has viewing access to and remove them
I see in my "User type report" that I have an email address of an old client with viewing access of 1 sheet. How do I find the sheet they have viewing access of and remove them? They were never a licensed user, but had been given viewing access to a sheet long ago. We have hundreds of sheets so need to determine which…
-
Hyperlinks / Update Requests
Hello, I currently have a workflow in place with a update request being send out with helpful hyperlinks with instructions for my users to view prior to checking off and item as complete. The issue is the hyperlink only works within outlook, the hyperlink functionally goes away when the user clicks on "open update request"…
-
IFERROR function question
=IFERROR(INDEX($O$19:$O$46, MATCH($A9,$N$19:$N$46,0)), "") My table ranges point to the correct cell lists (verified by the color-coding), but I do not get the correct output. I get the whole formula written in the cell as shown above, instead of the value in the table cell corresponding to the A column pulldown…
-
Is it possible to use conditional formatting on a column chart on a dashboard?
I have created a dashboard and added a column chart. I would like the individual column to change color once they have exceeded the goal. Is this possible?
-
Hiding NaN from Reports
I have a Report set up and I have it pulling in a helper columns where data isn't filled out until the row is "completed" via other columns in the sheet. I'm struggling to figure out how to hide the NaN values that show up in the Report because there's no data. See screenshot below. Ideally, I'd prefer to just have it be…
-
I can edit on my phone but not on PC
I am sharing a smart sheet with a business partner and we were working off the free plan at first. When the 30 day trial ended I could no longer edit so we both purchased the pro plan. However, my PC version of the sheet is still view only yet on my mobile app I am able to make changes as per usual. We have tried removing…
-
INDEX and MATCH across two sheets: a detailed explanation
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the greater Smartsheet community of how to easily utilize INDEX and MATCH functions to reference cells from another sheet by…
-
SUMIF Formula
Hi - I am having a problem with my SUMIF formula when it contains the 'Scheduled' column. My formula works if I remove the "Scheduled' column, but when I add that column, I get the message '#Invalid Data Type'. I need to have it included. I attached a screenshot for more information. Any help would be appreciated. Thank…
-
COUNTIFS
Hi All, I've been trying to put a metric in place for my dashboard which splits up how many tasks are Open or Closed within certain division. I am referencing the main works sheet and columns there for the range. I was also trying to reference my metric sheet for cell values for Open/Closed and specific division but gave…
-
Control Center Advance Functionality
For Control Center to be REALLY helpful, it would be useful to be able to set up advanced functions as part of a new item being spun up. Such as creation of: WorkApps (actual WorkApps, not portfolio WorkApps DataMesh Data Shuttle Etc.