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 …
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 …
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'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 p…
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 subta…
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…
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 tr…
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…
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 sh…
