-
Prevent deletion of rows if it contains locked cells?
We are trying Smartsheets for a project and are running into a major issue. The sheet contains checkboxes of things to do, along with dates, and who did the particular task. It is crucial that the 'Task' and 'Date' columns be protected. Unfortunately, we're finidng that if you are an editor, even though these two columns…
-
Barcodes count and verification
Hello all, I'm looking to implement a process where I can count how many times a particular barcode label has been scanned. This will help me to verify that all the items that belong to a single unit are leaving the workshop after going through the fabrication and painting process. Can you think of a process using…
-
eliminate INVALID DATA TYPE when using a IF statement to display the month
I am using an IF statement to display the month but when I don't have a date the column is displaying #INVALID DATA TYPE. I understand why this is happening but I don't know if I can also incorporate the use of an IFERROR statement nested. What is the correct way to eliminate the #INVALID DATA TYPE? Here is my IF Statement…
-
Formula Training
I'm training a guy to support Smartsheet for our company. He's pretty good with most of the functionality, but he has no experience with formulas. I thought I'd put together a training program for him to help him learn them - starting with basics, then building into nested formulas, etc. I want to give him some samples to…
-
Checkbox condition in a child row, conditional formatting of parent?
I have an uber parent row that is the mother of a group of related tests for software QA. In addition, some of the children of that mother have their own children. I would like any parent row to turn red if any of its children fail a test, as noted by a "Fail" checkbox column, and bonus points for conversely turning green…
-
How can I get the number of checkboxes checked in a single column ?
Hello, I'm trying to get the number of checkboxes that are checked in a given column (more precisely, A10 - Transcode colum) without using another column to do so (in this case, Valeur A10 - Transcode column which displays ''1'' when a box is checked and ''0'' when it's not the case). As you can see in the screenshots, I…
-
Allowing multiple contacts per cell leads card view is removed.
Card view is removed automatically when changing configuration of a contacts type column to multiple contacts per cell. I need that card view.
-
Predecessors (Finish to Finish & Finish to Start
I may have a basic misunderstanding & need some clarification. I have a task #3 (the Effective Date) of a contract. Further down the project I have another task.... #20 - Purchaser obtains an updated Survey & Title Commitment. Task #20 can begin on the Effective Date (task #3). Further down the project I have another task…
-
Trying to create an IF THEN function in smartsheet
My example is to select an material size value based on the material. Something like this: If [cell1]="4X8 Sheet" then [cell2]=32, if [cell1]="4X12 Sheet" then [cell2]=48, etc, etc. I have a dropdown list in the materials column to restrict the set of possible materials. Subsequently, I would like to take those values to…
-
Have User Filing Out Form Include Clickable Hyperlink
Hello, I am trying to see if there is a way to have someone completing a form to be able to include a hyperlink to where a file is. It would then come onto the Smartsheet so someone else could click on the link to get to the file in a shared drive. Many of the files we work with are too large for attachments and a…
