-
Attachment in Alerts (without attachment as trigger)
Hi Everyone, We have an intake form which is filled by our design team with project details and drawings as attachment. Once received, we review the details and allocate a project manager (PM). We have set up an alert to be triggered to the concerned PM once he is allotted the project. We want the drawings to be sent along…
-
If Formula Help
Hello, I spent some time with Pro Desk this morning, but we couldn't figure out the right formula for what I'm trying to accomplish. It is an IF(AND formula, where if data in a certain cell is "No", the result will display "Not applicable." Easy enough: =IF([Meeting Required]@row = "No", "Not applicable" Now the…
-
Form question - Possible App
Hello, I have built a form that we will be using for self checkin at our Health System for COVID19 where the employee will log their employee number, temperature, and answer the COVID19 questions before they begin their day. I would like to be able to have a App Shortcut to put on their mobile devices I know I can walk…
-
Using a report to show a section of a smartsheet
Good afternoon, I have a question for anyone who may have a better workaround than I do. We are creating dashboards for our clients that is essentially a one stop shop for all of the resources we provide them. We have a long sheet that keeps track of all of our task for them and I only want to bring in a section of that…
-
New Date Stamp Feature/Function
One of the new features announced at the recent Engage 2020 was a date stamp that would capture when a certain field changed--without having to employ the crazy workaround that is required to achieve this now. I could be mistaken, but I thought they said it was supposed to come out in October. With only two days left in…
-
Enhancement Request
Hi Would really like the capability to give access permissions at the folder level, not just the Workspace Level. The current capability means we have to add a person individually to each sheet in a folder. Would be much more user friendly to be able to provide access permissions for all sheets in the folder at the folder…
-
No Email Alerts
Hello, I am having difficulty receiving email alerts on a sheet I am running. It is a very simple set-up where I need an email every time a line is added. I have read through previous posts and none of the solutions are having any effect. I have ensured that SmartSheet has permission to email me, the sheet has permission…
-
How to modify an Alert notification
Hi there I have created an alert in my job sheet that sends an email to Managers when a job is finished. As the row is very long, the message squashes into one long thread in email. Is there a way we can alert specific columns within the row so that the notification is more readable? Much appreciated Geraldine
-
access to published dashboard
Hi. I'm having trouble giving people in my organization access to a published dashboard. Smartsheet tells them: "The published item that you are trying to access is only accessible to users in the organization that own that item." But they ARE in my organization. This happens regardless of how I set Access Control when I…
-
Column Formula with VLOOKUP using External Reference
I love the new column formula functionality! I'm converting to it whenever possible. I am trying to create a column formula that includes a VLOOKUP that uses an external reference for the data set. =VLOOKUP($ROWID@row, {~ Master List Range 1}, 2, false) I am getting an error message, and I think it's because of the…
