-
How can I update cell 1 with the information from cell 2 when cell 3 is "1"?
Hi, I want the selected cell in Column19 to pull through A, B, C, D, E or F if the search filed has a "1" in it. I have tried INDEX MATCH, nested IFS, but nothing seems to work. Closest I got was a 'No Match', but not sure why the corresponding letter was not pulling through. This is all on the same sheet with columns…
-
Multiple Forms, One Smartsheet
I created two identical forms (except for the name) and both of them populated into the same smartsheet. Is there a way to only see one form's submissions?
-
Can't find how to enable % Complete column
I am new to the app working in a Trial window. I have searched the Help but cannot seem to resolve how to enable the % Complete column. Dependencies are enabled. System Settings only gives me options for "None" or "Notes" for a % Complete column. Only thing I seem to get is the ability to add custom columns. Any direction…
-
What is quick way to manually enter current date (today date) in a row in smartsheet
Hi, I have to update project progress every day in a row in smartsheet, so every begining row I have to fill today date ex: 6/8/2023: step A done 6/9/2023: Step B done 6/10/2023: Step C done. In excel, I have quick way to do this everytime by pressing "Ctrl"+";", do we have similar quick way to fill today date likes excel.…
-
How to identify the reports and dashboards to which an external contact has access?
To those in the know, I've been made aware a couple of dashboards and reports has been shared to an external contact over time. I'm trying to identify all the resources they have access too, so I can consolidate and streamline the reporting. Short of asking the external contact to do a screenshot of their personal…
-
Smartsheet Automations
Hi Smartsheet Community, I need to create a Smartsheet Automation to move rows into an archive sheet when record id appears in the Primary sheet, but does not appear in the Uploaded sheet. Another Automation that I need to create is to copy rows into the Primary sheet when the record id appears in the uploaded sheet but…
-
How to set the reply-to on notification emails?
Hi, When the automation send notification emails, most of the time the reply-to is the sheet owner but sometimes it is the person who modified the sheet. Looking at the documentation, I found this article: Overview of Automated Notifications Sent via Smartsheet | Smartsheet Learning Center The article says this: "In most…
-
Connectivity Issues
Hello everyone! Has anybody been experiencing issues to load or connect to Smartsheet? My entire work organization has been experiencing issues to use Samrtsheet this week, specially on the afternoons. At first I thought it could be our internet connection but I'm able to use my mail, browser, etc. Its just Smartsheet that…
-
Conditional Logic on Likert Scale Not Working
Hi Community, I've created a form with conditional logic. All of my logic works perfectly except for a 'any of' Likert Scale response. For context, if a user submits a response of 1, 2 or 7, a secondary question should populate. The response list does include'N/A', i.e. N/A, 1, 2, 3, 4, 5, 6, 7. I have already attempted to…
-
Does anyone know why a link to an attachment would expire in 14 days instead of 30?
We have created automation to generate a document based on a submitted request. Automation then sends an email with link to our case queue to be parsed out to the appropriate people. Everything I can find on attachment links indicates they expire in 30 days or when accessed 100 times. Our attachment links expired in 14…