-
Dashboard Series (Font Size to Match Bar Size)
Hello SS Users … I am not liking this feature and think it makes no sense unless we are given an option to use it or not. I'd really like to see this changed back or upgraded with the option to not match bar size please. Shouldn't be too difficult coding that in. Thanks. Vince
-
Lock a Column (Prevent it from being moved to a different area)
Hello, Is it possible to have a column header be locked in place. For example, a spreadsheet with 5 columns titled 1, 2, 3, 4, & 5. Someone keeps moving column 2 next to column 5. We want to prevent other users from dragging column headers to different locations. Thank you!
-
Disappearing Links
I had several links (URLs) saved in a sheet for quick access to frequently used resources. All of the links (URLs) have disappeared. Many links were to Google Drive resources. What caused the links to disappear?
-
Portfolio Template with Capacity Waterline Help
I'm thinking of transitioning my current project portfolio to this template that includes a capacity waterline but I'm having trouble getting started. Usually the templates include a guide on where to start and how the data flows between the sheets, reports, and dashboards but I can't find it for this one. Thanks in…
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
Employee Reviews - Pulling & Averaging Category Scores
Hi all, thanks in advance for your assistance! I am working on building a new employee review process for my company and am caught up on one of the final steps. Here's where I am at: I have created an employee review form that individual managers will complete Each employee will have 3-5 reviewers The form submissions will…
-
New filter criteria/option
Hi It would be extremely beneficial to have a filter criteria to say Is in the Last Month or last week Is in the Next Month or last week At present, when you use in the last 31 days or last 7 days, depending on what date of the month you are in it shows different dates. If you could say last month or week it would stay to…
-
Invalid Operation Error on Dashboard but not on Report
Hello, I am using the Smartsheet Dashboard to communicate production status to colleagues. I have a widget on the dashboard meant to display the overall status of the manufacturing run by pulling the status of the last item on our task tracker (Condition37). The tracker is displaying the correct status, in this example…
-
SIMPLE Conditional Formatting is not Working
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…
-
Send row attachment with automation
I am looking for instructions to send all of the attachments on a row with automation. Here is what I currently have: Trigger: When a row is changed and an attachment is added Action: Alert Someone - send to specific people When the automation runs, the attachments are still not in the email. Am I missing something?