-
Sorting ascending order (monthly)
Hi, I'm having trouble organizing the column in ascending order. I'm trying to plot this into the dashboard and after Jan comes Oct as I'm trying to group them together. Before I tried not to put a number before the month that messed up the order more. Not sure how to fix it. Any input will be appreciated.
-
Report grouping by system generated date?
I'd like to create a report that groups entries by created date, without the timestamp. The entries come from a form, and adding a system generated 'created date' is more efficient. However the grouping function ends up splitting every entry separately because of the timestamps being different. Is there a way to group by…
-
Change a cell value If a certain Postal/Zip Code is entered, is it possible?
Hi there helpful people! I am using smartsheet to track jobs in order to then export a monthly report. I have approx 2000 postal/zip codes attributed to client sites within a particular State - and what I'm hoping to do is set up an automation (either within a workflow or a formula) where if a particular postal/zip code is…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Report Builder Automations
Hello Smartsheet Community, I'm building a report and I'm wondering if I click into an entire folder collection for my source sheet, will the report auto-include new grids that get added to those folders or will I have to manually add them as they get created?
-
Email automations in report not working
Hi. I need help with setting up a report to send monthly to specific email addresses every month. I saw others recommendations on automating the "Send as Attachment" in the report, which I tried and it is not sending the reports. Here's the steps I tried: I created a report "Gas Receipts Monthly Report" which will send a…
-
Company logo while using Control Centre
I've previously uploaded my company logo so that it appears on sheets and reports which are exported. However, reports that have been created within Control Centre have the Smartsheet logo when exported. How can I fix this?
-
PDF reports with totals
Is there any way to show the totals on a report when sent in PDF form? Anyone found a solution or workaround?
-
Line chart with multiple date-numbers traces
Hello everyone! I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are represented by increasing numbers 1,2,3,etc. and can be completed on different dates. I…
-
Conditional Formatting Not Updating in Reports?
I'm finding that conditional formatting is not consistently updating in reports, and my staff are complaining about it. See for example below, the "Rollinson Downstairs..." task highlighted has no conditional formatting even though the date has passed. If I open the Rollinson sheet, it then updates and updates the report.…
