-
Reports with Viewers
I would like to know if there is a way that viewers of the main sheet are able to work with the Reports. I know I can share the report but it seems they are not able to change the "What" choices. If this is not an option, would it work if I lock the columns and share the worksheet? Then would a collaborator be able to run…
-
Exporting Sheet Content into a Formatted View
We have a Smartsheet that is being populated from a webform that is collecting scholarship submissions. We want to provide a summary page for each application that includes the questions and answers. So if the sheet has 10 rows (applicants), we want to generate 10 different summary sheets in a view that is easy to read.…
-
Default sorting of attachments
Good afternoon, Is there a way to set the default sort for attachments? Currently it is by date and we'd like the default to be by name. Blessings, Loann
-
Salesforce ServiceCloud Users/Connections
Hi Smartsheet Community, We're thinking of some use cases for helping Smartsheet users utilize Salesforce ServiceCloud data more effectively and efficiently. Any Salesforce ServiceCloud users out there who would be willing to chat with us and give us feedback on our use cases? Even if you don't use ServiceCloud but know…
-
Pushing cell data to a map for plotting
Hi all, Im building a capability for an operations centre with smartsheet and was wondering of I can push cell data, such as an address to a GIS system to plot the tasks onto a map like Scribblemaps or the like?
-
Adjusting trip start/end date based on certain members holidays
Hi everybody, I'm new to smartsheets and I'm not sure if there's a name for what I'm looking to do. I volunteer for a small afforestation project in my local area. And want to make planning our planting trips a bit easier, as all our members are college students with varying schedules and holidays planned. (I already have…
-
Conditional Formatting for two end dates
Just to be clear I only have one end date in my sheet. The sheet has a conditional format set up to flag "At Risk" tasks when the end date has already passed. Here's the current formula: IF(AND([End Date]3 < TODAY(), NOT(Status3 = "Complete")), 1, 0) I want to add another condition to flag the task when it is within 5 days…
-
Increase width of bottom scroll bar
We use Smartsheet on Chromebooks. Is there a way to change the bottom scroll bar setting to make it wider, as it's very difficult to find/access? Thanks.
-
PLEASE tell me what is wrong with this formula
=IF(Status8 = "Complete", "Blue", IF([Due Date]8 < Today8, "Red", IF([Due Date]8 = Today8, "Yellow", IF([Due Date]8 > Today8, "Green")))) Very new at this, but I can't see the problem...
-
Keeping old and new data when needing approval/decline
We use Smartsheet for forecasting budgets per team. Each team has its own sheet with each line item that rolls up to sheets, reports, and a dashboard (with graphs and metrics). The columns represent both forecast and actual money spent per month (two separate columns per month). When a product owner adds a forecast amount…
