-
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.
-
Automation needed that alerts contacts on the 1st of each month only of tasks due for that month
I am having difficulty setting up an automation that alerts individuals on the 1st of each month. I need the people who are listed in the "Assigned To" column to receive one email notification that lets them know they have tasks due for that specific month. They only need to receive a notification of all pending tasks in…