-
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"…
-
Is there a way to show the history of a cell in another column on the corresponding row?
I have a due date column on my smartsheet, but would also like a column that shows the cell history of that due date so it is visible on the sheet without having to click on cell history each time. Is there a way to automatically populate the cell history from one cell to another cell?
-
How to view and use the Modified and Created fields in Smartsheet
Is there a way to capture the Modified By and Created fields in a sheet or report? I'd like to be able to create filters based on the current user in a sheet. Situation: Multiple users giving input on one Sheet. Issue: Concerns with data integrity and errors (overwrites, deletes, etc) from multiple users. Cannot lock at…