-
How to get attachment in the Alert Notification
Hello Everyone, I am trying to send the attachment to the other team member, my condition in the sheet is if the person checked the box in the sheet, the manager should receive the notification along with the attachment, which is attached to the row, but in my case, the attachment is not showing in the mail. Please suggest…
-
Why i am getting one combined email when adding multiple entries in a form
Hi Friends Hope you are doing good and staying safe! I am using Automation>Trigger>Alert someone feature to get email notification when user submits the form. I want to get individual email for each entry, however if user submits the form multiple times with different data, i am getting one combined email instead of…
-
Index/ Match not working
Hello all, i'm not seeing something and maybe a fresh set of eyes will see the glaringly obvious issue I have. From a Work Intake Sheet I have a list of project names and project numbers. All the project numbers are unique and auto counting. On a Expense Intake & List sheet I want to input the project number and return the…
-
Input data into sheet from a document
I love the function of taking data from Smartsheet and generating a pdf. Is there a way to reverse that functionality? For example, this format is easier to work with in a team setting: But I would like it to be uploaded to feed information back to the sheet in Smartsheet: Thank you for consideration.
-
Cell linking a sheet to a summary field in another sheet
Does anybody know if there's a way to cross-sheet cell link (1 sheet to another sheet) to a field defined in the summary section of a sheet? I looked everywhere in the "link from other sheet" pop up screen and couldn't find anything. Thanks, Rich
-
Data displays differently for different users in the same sheet
We have created a sheet that gathers data from various parts of our projects and resource management data. There's calculations in it with conditional formatting to colour the cells based on contents, but nothing more complex than that. It displays perfectly for the owner (via Edge) and another licensed admin (via Chrome…
-
Create sheet with just 1 row per person
I'm trying to create a new sheet that only has one row per Instructor from a master sheet. I have a master sheet of Instructors for my program and it is being updated as Instructors apply to teach courses. I'm trying to create a new sheet with only one row per Instructor from this for a summary and to help with sending…
-
Modified by cell-link@smartsheet.com
Sometimes "Modified by" is captured as cell-link@smartsheet.com ?? we are having formula columns based on modified by column, if randomly smartsheet captures it as cell-link@smartsheet.com, all the calculations are going wrong,...pls advise.
-
Smartsheet Bridge: Get Attachment
Hi, I refer you to Bridge: Smartsheet | Get Attachment article. The Get Attachment module returns useful information like: Attachment Type Created At Created By Email Name ID (of attachment) Mime type Name Parent ID Parent Type Size in Kb URL URL Expires in Milliseconds It returns the URL which allows users to download it.…
-
Formula to count multiple cell values and their dates
I am looking for assistance in creating a formula that will allow me to isolate values in the Provider/Resources cell, the Type cell and count based on Visit Date. Below is the a snapshot of the sheet. As you can see, there are multiple names in the Provider/Resources column, as well as the Dept column. The first name in…