-
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…
-
Formula Help - Count If (percentage complete)
I'm looking help on a formula to find the "Percent Finished", in row 1 column 1, by counting the total number of "Test Status" entries of: "Completed, Previously Enrolled, Enrollment Not Needed, Client Did Not Approve" and Dividing it by the count of "SAP ID"s. Thanks! Mary F
-
Exclude Rollup / Summary Tasks from Summary Sheet
Hi All, My Smartsheet has Rollup / Summary Tasks, Deliverables/Tasks and Milestones. On the Summary Sheet, I only want to count the actual Deliverables/Tasks i.e. not the Rollup/Summary tasks or milestones. I found how to add a column that determines whether a row is a child or a parent using - =IF(COUNT(CHILDREN([Task…