-
COUNTM for 2 Ranges
Hi, How can I count a total of values, in 2 diferent columns that are in 2 deiferent sheets? I need something like this.. =COUNTM({Range 1} AND({Range 2}) Thank you!
-
Formula for years and months between two dates - three dates
Hey Smartsheet! This is regarding service/employment time for employees and I want it in years and months. Right now we have one that works for just years and that formula is: =IF(DATE(YEAR(TODAY()), MONTH([Start Date]33), DAY([Start Date]33)) < TODAY(), YEAR(TODAY()) - YEAR([Start Date]33), YEAR(TODAY()) - YEAR([Start…
-
Update the cell value by 1 on the 1st of every month
Hi, I want to update the cell value by 1 on the 1st of every month. Suppose the current value of my Earned Leave Column is 10, on the 1st of every month I want to increment it by 1.
-
Formula to check box when a drop down has been selected AND it is a row of indent level above 1
Hi, I'm trying to automate a tick box when two other conditions are fullfilled. Firstly, one drop down is selected (in [Consultant Assessment] column) AND the row indent level not 0 or 1. This is what I have at the moment: =IF(AND(ISBLANK([Consultant Assessment]@row), ([Indent Level]@row < 2)), 0, 1) However, it isn't…
-
Counting checked boxes
Good morning (afternoon/evening). I have looked on the boards and tried to find the answer, but not working for me. I want to count the number of checked boxes in a single column. I have tried =COUNTIF([(Internal) Proposal Complete]1:[(Internal) Proposal Complete]23), 1)+"" =COUNTIF([(Internal) Proposal…
-
Date populated from a start date then a number of months after it
Hi everyone, I'm after a formula that will take a date from the last time a process was completed and then add a number of months to it e.g. process was last completed 01/01/2021 and needs to be carried again 6 months later so the formula would populate the 01/06/2021
-
Formula to find total amount assigned to someone?
Hi all, I hit a bit of a stumper and I was hoping to see if someone might be able to help. I need to find out how much square footage each person covers within a table, something similar to this: Since multiple people can be assigned to a specific building, I would want to divide the square footage by the amount of people…
-
Formula for at-risk flag, due within 3 days
Hi! I would like to have my at-risk flag turn red when 1) a due date is within 3 days or past the due date and 2) its not completed. I am using the below formula but it doesn't work: =IF(AND([End Date]3 < TODAY(-3), NOT(Status3 = "Complete")), 1, 0) I tried it with making it TODAY() and it works for overdue items, but I'd…
-
IF formula when multiple options are selected
Hello! I'm trying to see whether or not there's a way to create an IF formula based on one of several options select in a multi-select pick list. One of the fields that my current IF formula is based on has a multi-select pick list. If users select multiple options within that pick list, the formula doesn't formulate. The…
-
How to count rows if box is checked in separate column?
I have a helper column to identify the columns that require data to be entered. I need help creating a formulat that will do the following: Count the total number of rows within a specific range of the "Entity Details" column, and have a box checked in the "Data to be Entered Column". (For example Rows 10-25, that have a…