-
A "folder"/link shown in workspace list with all my sheets
A kind of "folder" (as it does not appear with the workspace icon in front of it) named "Sheets" is listed under Workspaces and the content is the same as in my Sheet folder outside Workspace (when I look in the left side menu using Browse). It almost seems like I - listed under Workspace - have created at "link" to…
-
Cross Reference Formula, Matching Two Conditions (with Multi-Select Dropdown)
Sheet 1 collects form responses for each new person added to our instructional team. First, they are asked if they are adding a vendor or individual. If the choose Vendor, the enter the [Vendor Name], and if individual, they select all of the options for [Role] that apply: developer, facilitator, instructor, mentor, and/or…
-
Auto direct risk from master register to project risk
I have a master risk register with a column controlled by Bridge to update when a new project is spun up in Control Centre.. that way it's easier for people to add risks for a project. Is there a way to automatically divert the risk from the master register to the respective project register? I have the project code as…
-
User type reverting to previous
I've changed a number of users access from provisional member to viewer a a number of reasons however when I review the list after several days the user has reverted back to provisional member despite they have not been active or logged in. Does anyone else see this or know why it happens?
-
Assigned to filter error?
Hi all, I have a sheet where we collect some suggestions, which are manually assigned to X person. I wanted to add a filter where users can see all suggestions which are not Complete and are Assigned to Current user, but also BLANK. But the BLANK does not function, at all. Even when I leave out any other rules in the…
-
Smartsheet + Zoho
I am looking to connect Smartsheet to Zoho using API Integration to get Timesheet data. I understand Zoho provides APIs for this. Has anyone implemented any such solution before? Also, any references or links to technical documentation\ POC\ guide on how to implement custom API integrations from Smartsheet?
-
Change Cell Value with Automation Workflow
I have a scenario where three people are providing an update on a project from different aspects, we have 3 fields for each person so the update requests prevent people from overwriting others update. We then would like to concatenate the 3 fields into one. Putting a formula into the field makes it hard to read without…
-
Enable {{Curly Brackets}} in manual "Send Update Request"
Issue: {{Curly brackets}} don’t work in manually created update requests (right-click → "Send Update Request"), unlike in automated alerts. Instead of displaying cell values, they remain as plain text. Current workaround: Manually copying cell data into the message, since all included columns in "Send Update Request" are…
-
Does anybody know how to reference an entire row from one sheet in another, based on one cell?
Hi, I'm trying to observe the number of forms submitted to a sheet per month and their status. So far I've managed to count how many sheets per month have been submitted (this is done in a second sheet from the one where the forms are submitted to). I believe that the issue lies in the fact that so far I've only referenced…
-
Rolling updates - can I automate data selection for dashboard?
I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes…
