-
Dynamic Field View Logic- Dates?
Hello! From the small amount of time I've spent working with Dynamic view as my company just got it, I am using it to allow those who submitted a request for a task to be completed via a form. I have set up the dynamic view to show them only rows their email is in, and hide some columns they don't need to see. What I was…
-
Can Projects added in Resource Management be automatically on a Smartsheet report?
Hi there, We have a custom solution build where we provision projects through a SCC blueprint, providing us a project toolkit and automated link to Resource Management with capacity integration. I am wondering, is it possible to have this also work the opposite way where we create the project in Resource management and…
-
Is there a way to Add Filters to Pivot Tables?
Hi - I'm in the process of creating a "Request Tracker" sheet with associated reports & pivots to serve up to a dashboard. I want to create a pie chart that breaks down "Request Type" but only for open requests (meaning, the Status is not one of "Completed" or "Cancelled"). So my question is, is there a way for me to…
-
#INVALID REF appeared some hours after Data Mesh was run, do you know the cause?
A Data Mesh was set up and initially it worked correctly. However, after some hours suddenly the filed that are linked were changed to #INVALID REF. Nothing was changed in the configuration. Could you please explain why this happened? and how can it be fixed? Thank you,
-
Data Mesh filter
Hello, I am trying to use a combination of Data Shuttle and Data Mesh to 1. Keep a main data set up to date and 2. Based on the region the data belongs to, allow coworkers access to specific fields. My original idea is/was to use Data Shuttle to import an employee data file to a Base Sheet. That file would be updated once…
-
How to remove a specific object from an array
Using Delete from Array utility - I don't know which number the object I want to remove is. How do I identify which object to remove and then remove that object?
-
Can Bridge Access Smartsheet Contact Groups?
I am trying to update contact drop downs based on who is in a Contact Group. Can bridge access Smartsheet Contact Groups?
-
Resource Management - adding environments
Hi. What is the 'best practice' when adding environments (eg, test environment) to Resource Management. Is it best to add them as a 'Placeholder' or as a named resource?
-
Sheet Transfers & Zapier
Hello! I have quite a few sheets set up with multiple zaps linking Smartsheet to other platforms. Does anyone happen to know if I transfer ownership of the sheet structured into a zap, does that break the zap?
-
Created Date Issue
hi guys, as you guys can see, the Check-in Column is a Created Date column, the left date is the date I pulled from created date =Check-in@row, but apparently it shows the previous date if my employee scan under 6-7 a.m