-
Formula to copy Child data to Parent
Hi, I would like to copy the child data to the parent and want to convert it into a column formula. Is it possible for the below scenario? Also, for the below I want for Parent cell from Child, I tried =MAX(CHILDREN([Close Date (SF)]@row)), can I convert that into a column formula to get all the Parent cells filled…
-
Dynamic Forms
Hello I have my project plan with certain people assigned to tasks. Each week i would like to have everyone fill out the percentage they are complete on the tasks that are associated with the week via form. I was wondering if in the forms i could have the user select their name from a drop down then see all the tasks they…
-
Count If Unique
Hi! I'm trying to figure out how to do a Count If Unique formula in Smartsheet. I know I can use the Distinct function in replace of the Unique function, but I need it to Count a specific criteria from another column? Thanks! Melissa
-
Want to Calculate the Number of days a task is in OPEN status
When the status changes from Open to In-progress the calculation gets reset to 0 days, Please Guide Thanks!
-
Forms with formulas
I'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back through the application to avoid sending separate emails. The formula is submitted to…
-
Formula to calculate checkboxes per row?
I have a smartsheet that is currently used to track assignments to staff members. Data is input via a form, those rows are added to the bottom of sheet and I have columns with formulas that track how many assignments each person gets and of what "type". What I would like to do but haven't figured out how: each row has a…
-
Remove the "0" in the column formula cell.
Help please! I am trying to put the item name (column name) in a cell if it's listed as "Complete". This is working for the most part, but if none of my IF criteria matches, it shows a "0" in the cell or if only the last column meets the criteria, it shows a "0" for the first column. See formula in Screenshot and the cells…
-
Add Two Summary Fields To A Cell
Hello and thank you in advance for any help you might be able to offer. I'm just getting going in smartsheet. I've built my first sheet with Summary Fields (brief pause while I pat myself on the back). I'd like to take those summary fields and auto-fill cells in the sheet. I've figured out how to do it with one summary.…
-
Return all rows that match any names in a master list
Hi! I have been trying to return set of rows from a data set (separate sheet) with one of the columns (Action Owners) being the criteria range. However, the criteria is not just one value, but I want it such that if the name in Action Owner matches any name my "master list" of names (separate sheet), it will return those…
-
Total Price Column for Parent is summation of Total price of Children
Hi, Can I know what formula to use in order to achieve Total Price Column for Parent is summation of Total price of Children. When I did convert to column formula it came with 0 value. I had used =SUM(CHILDREN()) and also the column properties is Text/Numbers. Thanks in advance. Krunal