-
Index/Match Cross Sheet References Broken after Control Center Provisioning
I'm having issues with Index/Match formulas to external sheet being broken on new sheet created through provisioning in Control Center? I have a different blueprint set up in Control Center that contains an Index/Match formula to an external sheet that works as intended and I can't figure out what is different The external…
-
Parent Child formula for Checkboxes
Hello, I am working on a checkbox column formula for a sheet that will function as a roll up but will not automatically check the lowest children. Currently I have this: =IF(COUNTIFS(CHILDREN(), 1) = COUNT(CHILDREN(Tasks@row)), 1) That formula works, but you have to manually add it to each parent row. I would rather have…
-
NetworkDays with IF functionality
Hi, I am trying to gather a sum total headcount for each day of the month based off another sheet that has a date range of each users visit. How do i capture the total headcount for each day a user is onsite? I have been using IF(NETWORKDAYS( START DATE, END DATE, = specific day) and get an incorrect argument error.…
-
=COUNTIFS Function does not appear to work
Hi all, I am new to Smartsheets and would appreciate a little help. I have a sheet with a list of UAT defect reports within it and I am using a separate sheet to try to calculate various statistics. When trying to calculate how may defect reports are open for an individual I have used the following formula: =COUNTIFS({UAT…
-
Join Collect - Return Multiple Values from a Multi-Select Column
Hi all, I have a change log where the "Assigned To" column has multiple assignees - I have another column where I would like to return the department(s) of the assignees, which is pulled from another sheet. However, when I use the following formula, it returns a blank result when I put two people in the "Assigned To"…
-
CountIfs Formula
Hello. I am new to Smartsheet and having some trouble with the countifs formula. I have two columns I would like to use - department and status and have created a sheet just for the formulas (to be used later on a dashboard). I would like to display the count of each status for the department (i.e. IT has 3 in progress and…
-
% Complete Based on # of Tasks Assigned
I need a Smartsheet formula that will calculate the percentage complete for a selected cell based on the count of values in the same row in column "Assigned To (Team)" and the count of value "Complete" in the same row. We have 3 teams that complete separate tasks for one project, which is created as a new row from a form.…
-
Automatically add formula to new rows
I have a sheet with a formula set up to find duplicate email addresses. But, when new rows are added, the formula doesn't copy to the new row. Is there a way to make the the new row also includes the formula. Sidenote: when a new row is created, it also triggers Zapier functions so I can't just drag the formula down into…
-
Count the number of occurances of text strings
I have 2 Smartsheets. Sheet 1 contains the data. Sheet 2 is a helper that I use to drive a dashboard. In sheet 1 I have course names. I don't want to have to explicitly code for each course as new courses may be added. In sheet 2, I want to return a value that is the course name in one column and in the next column return…
-
How to use IF
This might be simple, but I am a beginner. Team members will be pasting one of these 10 cities/counties into the Area column and selecting either “Experimental” or “Written” in the LOB column. I want their choices to automatically populate words into the District Column. Some have a 1 to 1 relationship, others have a 1 to…
