-
Dynamic View - Field Logic Work around
hello Smartsheet community! l am building a Dynamic View with some Field Logic added so whenever the fields meet certain conditions, the field is visible in the details panel. I know that field logic only works with Dropdown or Symbol columns, however the data fed in to the sheet is entered manually (free text). Is there a…
-
Can I create a chart in a dashboard from multiple cells that are not next to each other in a sheet?
Hello, I am brand new to Smartsheet and this form. I have tried to search answers to my question but didn't find it. I am trying to create a bar chart in a dashboard using cells that are not next to each other. Is there anyway I can create a bar chart from, for example, row 1, 2, 3, 6, 9, 12 and col 1, 2, 3, 4, 5, 6....
-
Data Shuttle - import multiple values from csv into a multi-select cell?
Is it possible to use Data Shuttle to import multiple values into a multi-select cell. If so, how do I format my csv to properly do so? Example CSV: "Last Name","First Name",Email,"Job Title","Faculty Type" Doe,John,"abc123@name.com",Professor,"1,2" The target multi-select column has the following values (and is restricted…
-
Why can't I grant Edit access to a report in a WorkApp?
I have several identical WorkApps (each for a different department). I created a new one (copied all of the content from a previous one that is working) but with this new one I am not given the option to allow Edit access to a report within the app. The option just doesn't show up, I only get Viewer or Hidden. Any ideas…
-
Data Shuttle: Delete all rows (indent): "Server timeout exceeded. Request has failed."
Hi! I'm updating a sheet using replace, but now I'm getting an error message. The first time I uploaded the file it worked fine, this is the Log: Rows updated 0 Rows added 7301 Rows deleted 7226 Rows filtered 0 Rows skipped 0 Column choices updated 0 But now the message I get on the Log is this: Delete all rows (indent):…
-
Locking Rows in Dynamic View
Hello, I currently have a report in Dynamic View that is used by project leaders to update monthly financial data. I understand how to set specific fields to read-only but not entire rows. In the screenshot below, I would like to lock the "Target" ROW (highlights in blue) but would still like the project leaders to be able…
-
Can Smartsheet send a notification to a TEAMS channel that is private?
When creating an automated workflow- i want to send a notification to a TEAMS channel. It seems that it will only work if the TEAMS channel is set to "Standard". I am currently trying to get a notification sent to a channel that is "private".
-
Viewing Calendar on Mobile App
Hi Smarties, Out of curiosity, is this happening to you guys? I have published a calendar in a dashboard (let's called it Playground) - using both Calendar view and Calendar App. It works great on the desktop, but I am getting the below icon on the mobile app? Is this happening to anybody else? Is this a bug or something I…
-
Can I change the order of my secondary grouping in the Calendar App?
Hi, I'm having an issue getting the order of my groupings for my secondary column to appear on the Calendar App in the proper order. I am using a multi-select column from my main sheet. I understand I can not dissect the individual selections from the multi select column, but the order they are appearing is incorrect.…
-
Data Shuttle - Skipping rows that need to be updated
I am using Data Shuttle to connect to an Excel file in OneDrive. I use a unique identifier column to look up that column in Excel and map it to the Sheet I want data updated to. I mapped the rest of the fields. It worked fine until few days ago. Now it is updating some rows, but not all. the Unique identifier has not…