-
Populate a column based on a Smartsheet User Profile data
Is there a way to access the fields in a Smartsheet User Profile. I have an Assigned To column which can contain a single Contact List type. Each single contact in Assigned To is also a Smartsheet User. I have a corresponding Assignee PH# column in the same row. Is it possible to populate the Assignee PH# by doing a…
-
Move Row - System Column name ERROR
I'm working to have a request sheet move rows to a active list sheet. I'm getting the following error and having trouble finding information on what column name actions I need to look to correct. Any help pointing me where I can find column naming rules to enable the Move Row work would be appreciated.
-
Adding more dependencies to a task, and now I don't have any start/end date info, just duration
I had a task that hadn't started yet, that was reliant on another task. I had start/end dates, a duration, and the dependency listed in it. Now I need to add 2 additional dependencies and see how it impacted timing, but it deleted the start/end dates when I added these extra dependencies in. If I try to put today's date in…
-
Can someone send examples of a user policy and access provision form that you have developed?
I need to develop a provisioning/deprovisioning form to be used by our internal staff as well as our external vendors that will be uploading data and documents to our new Dynamic View Smartsheet. I've seen one other question similar to mine, but it didn't offer useful or relevant information. I'm hoping someone has had to…
-
System admin rights
Hello, I am system admin and I have some questions about my exact permissions. Based on your documentation located at a system admin can edit any users, including other system admins. But, in reality, I can not delete other system admin ( the action is greyed ) and apparently, some of the role can not be removed: So, as…
-
Update Request Glitch
For the past 3 days, our update requests have been going out with glitches. When our staff presses the blue button to open up the form, instead of seeing the row information we sent out, they see pages of the text that we put in the message body of the email asking them to fill out the form. So if a request sends out 5…
-
Map pin not available
. I am using the smartsheet app on my android device to access a grid sheet. When select cell, do have map as an option. The barcode is option, but add coordinates column. Can anyone advise why does show up option?.
-
Cross-Sheet References with Contacts
I don't know if what I'm trying to do is not possible within the application or if I'm just missing something. I have created a form that the user selects their name from on the dropdown list. On the corresponding sheet, I'd like to populate their email address and office code by using a master contact list in a different…
-
Count total of RYG balls
Hi, can someone please help me - I am trying to count the total of Red, Yellow and Green Balls in a column and cant get my formula to work. Currently my formula reads =COUNTIFS([Status2]4:[Status2]33, "GREEN", "YELLOW", "RED") thank you
-
How to deliver notifications by individual row after multiple row update
Hello Community! I would like to to have smartsheet deliver a single email notification or Microsoft Teams alert after a user updates multiple lines. Right now, I can update multiple lines on the sheet but only one email or notification is sent with the changes grouped together. I want the individual lines that were…