-
Autofill child row cells with information from parent rows
Hi! I am trying to get my Smartsheet to autofill information in some cells based on the parent row. The sheet is mainly viewed in card view so when my teammates add subtasks they don't fill in basic info like the team working on the project since that is already in the parent task card. I tried a basic =parent but that…
-
"mouse over" interaction on a dashboard
Idea: enable "mouse over" functionality on dashboards. For example, an explanatory field (black box) could be activated by a "mouse over" over an info field (i) (green circle). Example see screenshot
-
Sharing Contacts
We currently cannot share our contact list with other users. This is very cumbersome for our company. We use Smartsheet to create a punch list for our vendors. We need multiple users from our organization to enter in punch lists for peoples, however, since I cannot share my contact list with my colleagues, we end up having…
-
IF(CHILDREN()) ? - Child inherits parent traits for entire column
I could've sworn I'd seen this but now I can't find it: We have a sheet for incoming project requests. Our general population can request multiple new mkt materials (printed direct mail, email, outlook MSG, etc.) for a campaign in a single 'ticket.' Then our PMO hotseat creates a new child row for each of those unique…
-
Hello from Biotech
I work in Regulatory Biotech and started using Smartsheet to summarize our Global Submissions data to the Global Health Authorities. Look forward to Smartsheet updating the functionality of charts!
-
Workflows updates
Hello, I wanted to know if there is functionality for the following: I have two sheets, #1 Master and #2 Calendar. I have set up an automatic workflow: when a tick box on sheet #1 Master is ticked, a row is copied to sheet #2 Calendar. I then realised that if I needed to update anything on #1 (after the row was copied…
-
Option to Toggle off Admins Receiving Access Request Notifications
With the new update rolled out last month, all sheet/workspace Admins now receive access request notifications instead of just the Owner. This is causing major headaches for the large corporation I work for. We have thousands of users and many do need Admin permissions to perform their tasks in workspaces. However, they do…
-
Please Help
I am trying to use this formula- =IF(CONTACTVALUE({Hardware}) = "Andrew Mattos", [Points Bucket]@row - 10, 0)- Basically I want it to search my TR Project sheet for the Hardware column and if it see's Andrew Mattos contact to subtract 10 points from my point bucket column in my data sheet. It keeps coming back Unparseable.
-
Locking Monthly Dashboard Reports
Hi there, I am trying to find a way to "lock" a dashboard so that the reports do not refresh on the dashboard for a month. If this isn't possible are there any suggestions on how to create a monthly report utilizing the dashboard? Thanks!
-
Cascading Forms
Cascading Form data sets is one of Smartsheet's missing capabilities that I believe would be a game-changer for many alternative providers. Cascading forms are a very effective technique that can be used to compress form data and limit down options in order to narrow a workflow or collect more accurate data. Recent usage…