-
Sharing report without providing access to underlying Smartsheet
Hi, Is there a possibility to share just the report without providing access to the underlying sheet to key stakeholders? I know that this is possible using the dynamic view add-on but does anyone have any sort of work arounds to be able to do this in some way or the other without using the add-on? Also, if I share the…
-
Card View grouped by multiple views
Hi, Are we able to do multi layer views? For example, have a view by Status which is further broken down by Assigned To. Similar to screenshot below: project are broken down first by Status, and then by each person assigned to the project. Thanks
-
How do I select which data from a report to use for a chart?
Currently, my chart widget is defaulting to the entire data set of the report. I just need to shart selected data from it.
-
Chart Colors on Dashboard
Hello, I have a dashboard that has two different charts, one is a pie chart and one is a bar chart. Both charts are pulling from the same data source but assigning different colors for each variable. For example: Location1 is red on the bar chart, but blue on the pie chart. Why would it assign different colors if it is…
-
Auto Number/System
If I want to set the Auto Number (Ref. No.) to start from the specific row, How can this happen? For example, If I want to start the no. from row 208
-
IFERROR not working
I've created an intake column to count the # of days based on a date in the Approval Request Submitted column. I want to use IFERROR to remove the INVALID DATA error and replace it with a "0" (zero). my attempts were; =IFERROR(ISBLANK([Approval Request Completed (Date)]@row), NETDAYS([Approval Request Submitted…
-
Blank Destination Sheet when trying to build Copy Rows WF
Hello Smartsheet gurus, I am attempting to build out a workflow that automatically copies rows over from a source sheet I have Admin access to, to a destination sheet. My problem is, every time I try to select a destination sheet, the selection wizard is completely blank! Any idea why this is happening?
-
Power Automate Smartsheet
Hi, I am trying to insert a new row based on a trigger that when a new row is created to a sheet. I have used Zapier a lot in past to setup these tasks but Power Automate is way to complicated. I am unable to map column name from triggered sheet to new sheet where I would like to insert row values. Also, the columns name…
-
Multi checkbox with logic to dropdown fields
I'm creating a form for job recruitment. What I'd like to be able to do is have a multi-select checkbox with logic that only opens an additional field for the checked items (pic below). I set up a Logic for each individual field, but when I try to select multiple items it won't open any. If I only check one box it works…
-
User Permissions
Hi I have set up a Workspace called TDR under which I have the PMO template. We have numerous Project Managers and I want to allow them to create new Project Level, project folders, from the Template folder. What access do I need to give these Project Managers? They are currently assigned as editor. When they "Save as New"…
