-
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…
-
How to alert a relevant contact
I work in Customer Service (CS) , and we receive and correspond customer requests in Smartsheet. I set an automation, [Trigger: When rows ard added, Actions: Alert someone, Recipients: Contacts in 'CS'], with which I receive other than my own portion. I was wondering if there is a way to alert an assigned Contact of a row.
-
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…
-
I have dashboard charts using reports and "<unknown sheet>" appears in them
Is there a way around this? It is appearing in the Sheet Name list and just looks a bit unprofessional. My reports do use summary but not group.
-
Constraining a deadline that has predecessors
Since Smartsheet does not have constraints built into the scheduling software, I have trouble with drifting deadlines. A proper schedule has predecessors and dependencies assigned to tasks and this string of links needs to logically end with the deadline. The problem is that as soon as someone makes an adjustment to a…
-
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…
-
Automated emails not sending attachments
I am having trouble with Smartsheets not sending not sending attachments. I have it currently set up where I have to approve it before the email gets sent out. Once I approve it I have a separate automation send an email to group 1 or group 2 based on which option they pick in the form. At first I was having trouble with…
-
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…
-
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…
