-
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…
-
Merged: Auto timestamp
This discussion has been merged.
-
Missing Attachment as Notification Trigger - Smartsheet Automations?
I have built out a multi-use form that, depending on the user, requires attachments to be added. Since I cannot conditionally require attachments in the form I am trying to build an automation that triggers a notification to the form submitter if they neglect to add an attachment when it is required... but I continue to…
-
Automation to send form for a sheet at specified cadence
It would be nice in the automations to send out a form at a specific time, weekly, monthly etc. to emails so staff can be reminded to send over form responses on a project. Not an update, but fill out a form from scratch.
-
Cross referencing same range across multiple sheets
I am using one sheet, call it Program Data, as my source data for piping into my many Project Sheets. The Project Sheets have a Project ID in one cell that determines which line of the Program Data sheet to call out (e.g. Start Date, Team Lead 1, Team Lead 2, Team Lead 3, ...). I can't find a way to link each cell without…
-
How do I create an IF functions that will change my status color if information is in the cell
I am trying to have my event status which is (symbols) update to gray, red, yellow, or green depending on if 2 cells contain information (Green), or one cell or no cells have information and is more than two weeks from the date (yellow), one or no cells have information and is less than two weeks from the date or event is…
