-
JOIN, COLLECT with MATCH
In Sheet 2, I want to JOIN and COLLECT a group of values from Sheet 1, separated by a comma. I have this figured out: =JOIN(COLLECT({AutomatedCourseCopy-CRN}, {AutomatedCourseCopy-CRN}, <>"", {AutomatedCourseCopy-UseinBCC}, <>"", {AutomatedCourseCopy-College}, CRN1), ", ") + "," I have a set of values in Sheet 3 that…
-
Gantt Task Completion bar based on dynamic % Complete
Is there a way to set a dynamic column to be the % Complete column for the purpose of setting the Task Completion bar? All help is appreciated.
-
Date calculation - work days only
I found the formula for date calculation (today's date minus 2 days is =[First Test Date]5 - 2 in my case). But I want to make sure it's calculating only work or week days. Is that possible? Thanks, Jennifer
-
Use Countif to count the number of tasks assigned to a worker?
Hi, I'm sure there is a quite dimple solution to the this, but I am having trouble. I want to count the number of rows assigned to each contact, and I used the formula below: =COUNTIF(Assigned Work:Assigned Worker, "contactname") The formula returns the error #UNPARSEBALE How can I fix this?
-
calculate minutes a delivery is late
I am wanting to create a formula whereas I have an expected delivery time and actual delivery time and need to determine how many minutes the delivery was late. Does anyone know what formula to use in Smartsheet?
-
Auto group like cells
Is there a way to auto group cells that are the same, and add a count of them next to the parent cell? For example, I have a sheet that looks like the first screenshot (ex1), it's a list of SKUs within a program and a project. I want to group all SKUs within the same program/project and count the number of SKUs (see ex2).…
-
Formula to return more than one value - Please help!!!!!
=INDEX([Job Name]1:[Job Name]15, SMALL(IF([Job Number]22=[Job Number]1:[Job Number]15, ROW([Job Number]1:[Job Number]15)-ROW([Job Number]1)+1), ROW(1:1)))
-
Date field minus 'TODAY()
Hello All, Could someone please explain why the following doesn't work or a solution: I have a date column with a mix of dates both past and future. The next column is a column to say how many days till this date occurs. Therefore if it is in the future (i.e. date is the 30/10/20) then the second column needs to say 534.…
-
Is there a way to use a countif formula if the cell reference is a formula as well?
Hi All, Any help would be appreciated. I get #NO MATCH when I run the below formula. Is it an issue with a formula referencing a formula? ="Not Completed: " + COUNTIF([Column3]2:[Column3]24, FIND("Not Completed", @cell) > 0)
-
IF auto generated number in Row matches anywhere in 2 sheet columns then checkbox checked
Hello, I am trying to input a formula that automatically checks a checkbox when an auto generated number from a specific row in one sheet, is found anywhere in a column from 2 separate sheets. I've tried to make it work by referencing just one of the two sheets but it is behaving strangely. The formula I tried is…