-
Linked Cell Format Issue
Hello everyone, I have tried looking for this topic, however, I can't seem to find anything. I have a source sheet with dollar amounts and the cells include a number such as $100,000.00. When I link the cell to a new sheet, the number shows up as 100000 Any idea how to fix this? Thank you. Sincerely, Diego
-
FILTER
Hi, Please can someone suggest an dynamic alternative for Smartsheet to the FILTER function that Google Sheets have to include in a report. I have a list of Asset I.D's that have multiple statuses at any given time. I would like to capture each Asset I.D assigned to each person according to the Asset's status. ie: all…
-
Cross sheet Formula to pull in column value
Hello, I have a Master Server Inventory sheet with columns such as Server Type, Server Name, Recovery Method, and several other columns with common data that has to be collected for all servers. I need to create a variety of separate sheets with detailed configuration data about each server. I want to reference and pull…
-
Metric Sheet Calculations for a Dashboard
Evening All, i'm looking to see how I can add to this formula a rule to not include sales variances of 100%. This shows when I am comparing year over year sales and the site does not have those figures to compare. =IFERROR(AVG({Sales Variance}), "") Many thanks, Sarah
-
Jira Connected Sheet and Hierarchy re-arrangement
Hi- I have been doing some searching on the community and cannot find a clear reason or explanation as to how to to set up the "Optional: Define Row Groups" I cannot find any documentation or help videos on YouTube or the community that explains how this works. Here is a screenshot of my sample project Here is what each…
-
Capture date when row changes
Hi, I have a status column in my row that changes from "animating" to "approved" and would like the start and end date columns to update when status is changed. ie: 1. When status column changes to "animating" - start date needs to capture the date(fixed value) it was changed to "animating" 2. When status column changes to…
-
Metric format in dashboard
I am trying to display a date in a metric on a dashboard, all the sheets have the date displaying DD/MMM/YYYY but the metric displays DD/MM/YY. How do I get the metric to display the date in the format that I desire?
-
Re-Title Notification Header
I recently used one of the existing templates "Contract Management" under the Client and Customers in the Solution Center, and it worked great. However, When my users get a notification the header still shows the old name (see attached). Please let me know how to make this change.
-
Using CHILDREN(cell address) as a range in SUMIFS
I am trying to find the total of Task Total Hours only for rows with a tier level of 2 and where % complete = 1. I am writing this in a summary cell in a mini-dashboard that requires me to write the formula in the % Complete column. I am trying to use CHILDREN(cell address) as a range. What I have read leads me to believe…
-
Can a Report Display Project Dependencies?
Hi, I created a grid, with each row in the grid representing an individual project. I set the predecessors between the various rows, so Smartsheet draws the links between the various projects. I need to show this grid, including links between projects, on a dashboard. So I created a report using the grid as the source, but…
