-
Which function to use to return Company Name + Lowest Minimum Weekly Rate
Hey Everyone, I've tried to use VLOOKUP for this but by having my company names in different columns, i'm not sure what's the best way to return the values I am looking for. I want to review the weekly rates and have it return the minimum of them with the Company Name appearing in column titled "Lowest Rate". What other…
-
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…