-
Help figuring out which formula to use
Hello! I am fairly new to using Smartsheet and need help figuring out if what I'd like to do is even possible and what formula I would use (would it be index/match?). I would like to pull information from one sheet to another sheet. What I am trying to come up with is: IF the "PRINTER" ON PRINTER LEAD TIMES sheet is the…
-
How to count children cells from % complete column - countif not working
This is for my % complete column. I'm trying to count the children tasks if the % Complete is less than 100%. I'm using this formula: =COUNTIF(CHILDREN([% Complete]):([% Complete]), <100%) but it is not returning a count, just displays the formula as it isn't correct syntax but can't figure it out. Thanks in advance!
-
Looking for a Formula that will count if multiple values are true
I am working to keep track of under represented minorities we have in our classes. We are able to get a formula that keeps track if they belong to one Like Hispanic or American Indian, but we do have some students who belong to more than one of these group. We use this formula for Instance to gather if they were Hispanic…
-
Cross Sheet Joining Automation
Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox that initiates a purchase request next to each item. My initial stab at this is when…
-
What formula can I use to calculate years/months/days of service?
Hi there experts-- I'm currently using this formula to calculate employee length of service, but it is adding the months and years together (so the total years are too high): =ROUND(ROUND((NETDAYS([Hire Date]@row, Today@row) / 365) * 12) / 12) + "yrs " + MOD(ROUND((NETDAYS([Hire Date]@row, Today@row) / 365) * 12), 12) +…
-
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?…