-
A Template that is more friendly way to set this up
I hope that my screenshot is helpful, but i am still using new tools in Smartsheets, but i was wondering if anyone had any idea of a way I can set up my 1x1 meetings, per supervisor in Smartsheets. So i have 3 departments, and each department has about 12 supervisors each, and those supervisors have about 12-18 employees…
-
Send Emails to the Comments section of Dynamic View
I am trying to create a log of the actions taken with on a row. We are using the "@teammember" feature to send email updates to individuals out of the Dynamic View comments section. It was asked whether there is a possibility to link this in reverse and forward an email from an external source (supplier) back to a row?…
-
Merged: Sharing contacts in different sheets
This discussion has been merged.
-
Change Cell Workflow across sheets
I know that some of this can be achieved with linking and some manipulative formula but I think it would be great (at least for me ;-)) if there was the ability to change the content of a cell on one sheet from an automation on another. My scenario: I use a date/time based automation to copy pertinent cells from one of my…
-
I am looking to use an Index match to concatenate a persons roles
I have a sheet to track workers roles however, some people are listed multiple times as they have multiple roles because depending on the project their role is different. I was wondering if there was a way to use an Index(match( to either concat all of their roles in 1 formula without the use of a helper column. My current…
-
keeping information current / between two sheets
Hi, I have several worksheets, one being the master. I have figured out how to "copy" a line from one to the other, but when that line changes, it does not update the other sheet. How do I ensure the two stay in sync? as an example - in the secondary sheet, the line changes from planned to completed, but that change is not…
-
CTC hours used by the task and role month-wise and visualize it
Hi, I am trying to figure out how to calculate the CTC hours month wise used by the task and the role seperate. Is there any way to find it using formulas or widgets? Appreciate your help
-
I want to send Photos
I'm looking for a solution to send photos for a daily project update in an automated fashion, when attached to a row/grid via form. We've tried inserting photos into the columns however this doesn't pull the photos into the automated notification/email. We've tried including attachments in the automation and that doesn't…
-
Submissions are via a form to our smartsheet - manually adding subtasks can I automate?
We have our team submitting requests for work via a form with a few required columns and some nice to have information to generate into the Smartsheet. We have been manually copy and pasting the subtask rows each time a form is submitted. then we indent those to get the parent child relationship. They are always the same…
-
Automation Notifications if 10+ rows change
Hi All! Need some help with a specific Automation notification when a specific criteria is met. The automation I would be after would look something like this: Everyday 100+ lines of data are added to the sheet, this tracks a specific item. I am wanting an automation that triggers an email when 10+ of the same item for the…
