We have daily asset inspections that are submitted via a form and I'd like to: Create a daily Workflow that will send only the assets that had an inspection issue on that date, as well as the issue description. (Columns are: Asset, inspection yes/no questions, and description of issue) . Rows are each date an asset…
Hello to all. I am using Smartsheet since many years. So far I didn't share my experience with the community. This is about to change now. I plan to post regularly on these topics: - experience with Smartsheet in large industrial projects - tracking progress of projects - forecasting end dates of projects - using…
I have a sheet in which there are about a dozen columns. Looking for one of the columns (for each row) to be locked until certain criteria are met in a different column of that row.
Hi everybody, I am currently trying to set up the smartsheet-Jira-integration. A lot of things really work great but there is one thing.. I want to have Smartsheet as the "leading tool" for handling of predecessors and therefore sync this information to Jira through the issue links field. To give a simple example, I used…
Hello, I have four columns: Task | Hours | Assigned to | Total hours The 'hours' column is how much time (hours) it will take to do the task, the 'assigned to' you can assign the task for more than one person. Now I need the 'total hours' column to show me how much time it will take for a task (example: Task1 takes 1 hour…
I cannot figure out how to email attachments created with the create a document workflow. I have send alert on attachment and the email goes out with no attachment ( include attachments is checked in workflow). I'm getting frustrated...help!
I have a sheet with a status column. I would like to have the statuses in that column automatically updated based on when users make their updates in three other sheets. I thought I could use a workflow but I don't want to update the full row from sheet to sheet, only the cells in the status column. What is the best way?
In smartsheet one sheet called Holidays have 3 colum Name start_date end_date jap 03/March/2023 05/March/2023 ALex 01/March/2023 02/March/2023 jap 19/March/2023 25/March/2023 other smart sheet called as class List having 4 colum Class CourseDate TeacherName Conflict math 02/March/2023 ALex False English 20/March/2023 jap…
Is it possible to hide highlighted comments from SmartSheet notification
Hi all, this might be a simple question, however I'm a little stumped. When creating a workflow and choosing "Send to specific people", where is Smartsheet pulling the options for a name to choose? In my screenshot, it is showing individuals with their name & email address and some with just email address? We have a column…
