-
Nested IF and
I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine: =IF(AND([Status1]3 = "Low"; [Status2]3 = "Low"); "Low"; " ")…
-
Adding Months to a Date
The Date formula allows addition but I get errors when I cross months by adding days or when I cross years by adding months. (Haven't tested years with adding days but that also crosses a month so I would get an error anyway. I need it to act like Excel and actually add a year for each multiple of 12 months in particular.…
-
SCC Nesting Summary Data
Is it going to cause any issues if I nest (indent a couple levels) data inside a sub-category, inside of a main category? (see attached img)
-
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)))