-
Handling Duplicates
Bula (Hello) what is the best way to handle duplicates in a smartsheet grid? conditional formatting seems to come to mind, however, what if we have a scheduled import of data, e.g. via DataUploader or MS Power Automate? we haven't found any methods or features there to handle Updates or Duplicates. looking for any other…
-
Determining Workflow trigger criteria
Hi, I asked a question but from the reply I received I think I asked it the wrong way so I am trying again. I am new at automating in SmartSheet so forgive the simple question: I created a Workflow which is a reminder email that needs to go out to several people 3 days prior to a Finish date if not 100% completed. The…
-
Question about users
So in Smartsheet, I can give people permissions to a sheet on the sheet level and it will prompt that person to create a smartsheet login, however they do not show up when I look a the users in user management. If I then re-add them through user management they are confused because they will receive 2 separate user…
-
#PERMISSION ERROR
Hi, A colleague of mine owns a workspace (for a project) with different folders and files. In one of the files (grid), she is using the following formula =Amount@row * (INDEX(COLLECT({FY22 - Currency Conversion Rate Range 1}, {Currency}, Currency@row), 1)) Except that the formula is returning #PERMISSION ERROR. The error…
-
Workflow assignment question
Hi, I am new at automating in SmartSheet so forgive the simple question: I created a Workflow which is a reminder email that needs to go out to several people 3 days prior to a Finish date if not 100% completed. The conditions part of this workflow is straightforward, but I am unsure how to connect and activate it. From…
-
Pre-populate form using URL query
I'm trying to pre-populate dates from a schedule to an inspector request form, but only the first field (Start Date) is populating, the End Date is not. Here is my code with URL xxxx out. ="https://app.smartsheet.com/b/form/d485bfc4cbfc471882eb77ed6042ace9?Start%20Date=" + [Start Date]@row + "&End%20Date=" + [End…
-
An attachment to a comment
Hi, I am using the "@" to notify a specific person and then attaching a file into the comment. When the email alert goes out, can it include this attachment? Or must the person go to the sheet to view the attached file. Thanks!
-
Task Name on Every Page of Exported Gantt Chart
I am experimenting with exporting Gantt Charts to PDF in a format that is easy to read. What is vital for this is for the task name to be visible on every page of the PDF. I've tried freezing the column, but that doesn't seem to work. Is there anything I can do to achieve this? The PDF below may help explain what I mean.
-
Preventing requests for access to Smartsheets
We use Smartsheets as a way of sending the requested information to our staff. We are constantly receiving requests to access the sheets. They only need the attachments. It's a major annoyance, but I understand since there is a link to request it. Is there any way for that link to be eliminated, blocked, disabled, etc?…
-
Can I recover a deleted proof?
I accidentally deleted a proof along with the versions and markups associated with them. Is there anyway to undo this or recover that data?