-
Auto create unique IDs for both Parent and Child Rows for Test Scripts
Help with logic for Test Script auto creation of the Test Case ID (Parent) and Step Number. Since this is Parent / Child the Column properties for auto / number system will not work. Step Number: I created formula to auto generate step number ID by looking at the Step Details column and if the cell in row has any text/data…
-
Automatic Finish date and Finish time columns for a 3D Printer Sheet
Hello everyone, I am creating a sheet for my 3D Printer and I need some help as I am new in Smartsheet and in using functions. I want to make the "Finish Date" and "Finish Time" automatic, meaning once I input the Start date, start time and duration, the Finish date and finish time will automatically show when my 3d print…
-
Formula Help
Hi everyone- I am not sure if this is possible. I am trying to figure out a way to pull in a date of a course completion based on identifying the employee, the course they took, and the date of completion of said course. My source data sheet has this info with example data Course Code Employee ID Date of Completion "course…
-
CountIf for check boxes
Good afternoon, Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box? Thanks
-
Countifs formula
Hi, I am trying to count the number of cells that have CX Planned value on the reference of CX Status Column and at the same time CX Month reference should be dated as 03-01-22, below don't seem to be working, when i do separate countif formula they work but of course don't give what i want. What am I missing here?…
-
Dragging vlookup across columns
Hi there, I'm trying to pull a whole line of info from one sheet to another (same data different use case) using VLOOKUP. It's a perpetual need so copy/paste is not sufficient. =VLOOKUP("System Total", {Calculated count Range 1}, 7, false) The formula is fine but I am currently having to manually update column_num every…
-
How to count the times a person is assigned to a defect status
Objective: Have dashboard that reflects defect status and who is assigned to it, if blank then "Not Assigned" Example 1 Jake has three defects assigned to him. 2 = "Intake" 1 = "Vendor In Process" Example 2 Eric has 5 assigned to him 1 = "Resolved"; 3 = "Ready for Retest"; 1 = "In Process"; For any defects not assigned,…
-
Closest Date in the Past
Hi, I am currently building a ranking that I will display in a Dashboard. I need to grab data from another sheet that is the closest in the past to keep it up to date. Any suggestions for a formula?
-
Check if a date is within multiple ranges
Hi there, I'm trying to figure out whether I could write a formula to check if a given date is within multiple ranges. Concretely, I have two sheets: One where I book people's time to work on specific tasks Another where I keep track of people's holidays What I would like is to get an error message if I try to book Yann…
-
Formula Multi Select in Dynamic View
Hi, I have a column where someone enters a multi-select list from a form of missing documents. Someone will then track down those documents and delete them from the multi-select cell until all documents are found and the cell is blank. I want to be able to track which documents were missing though. So I made a formula to…