-
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…
-
JIRA Sub-Tasks remaining estimates do not roll up in main task in Smartsheet
Hi. I have a JIRA project that is comprised of tasks and sub-tasks. The sub-tasks have remaining estimates that sum up at the task level. For example, if I have 3 sub-tasks that have respectively 1, 2, and 3 days left are shown as 6 days remaining at the task level. I sync it with Smartsheet, and I use the Remaining Time…
-
Automated export and Automatic upload
Each time a row is added (which is requiring an approval) i need the sheet to export the new data, to either an excel spreadsheet or google doc and upload to a secure site. The other option would be to do this based on frequency like nightly, but I guess the real question for me, and yes I am both new and green here, can…
-
SUMIFS Based on Parent and Children Criteria
Hi there! I am trying to make a master reporting sheet that is just a sum of another source sheet based on specific criteria of parent and child rows. It's a two step SUMIFS that I can't seem to get straight. It would need to be a sum "grand total count", if hierarchy 0 month = specified month and hierarchy 1 matches…
-
time calculation
Hi there, I am a newby here and I must say that smartsheet looks good. The only thing I am definetly missing is a way to calculate time This is what I need to show: Start End Duration h Price per hour Price total 09:00 10:30 1,5 100,00 150,00 Start and End time can be put in manually Duration must be calculated…