-
Lock/Unlock a COLUMN when criteria are met
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.
-
Functions for synchronizing Predecessors and Jira Issue Links
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…
-
SUM of Hours column
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…
-
Email attachments generated from the Create Document Workflow
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!
-
Sheet to Sheet Cell Updates
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?
-
checking dates in two sheets
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 there option to hide comments (Default from SmartSheet) in Notification
Is it possible to hide highlighted comments from SmartSheet notification
-
Contact List For Approval Workflow
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…
-
Workflow not showing all dropdown options
I have a simple workflow that changes the value in some cells when "business Critical? is not set to no but for some reason not all the values in the dropdown show up the last one just isn't there and when i try and copy that last option into the workflow it just doesn't recognize it and works the same as if its not there…
-
Update same Column Cell value
I have two columns id and Name . when user enter something in column Name in any cell . all the rows having the same id name Colum should be updated to same value entered by the user Any way to do by formula or workflow user enter abc in 1st row with id 1 id Name 1 abc 1 2 3 1 2 output id Name 1 abc 1 abc 2 3 1 abc 2