-
Smart Sheet Summary for average time between two dates for two columns
Hi all, I am having some issues working this one out and am hoping someone might be able to help! I have two columns in my sheet that I am interested in, "Predicted UAT Start Date" and "Actual UAT Start Date". I then have many rows for each of our different projects. What I would like to know is the average amount of time…
-
OFFSET function equivalent?
I realize there is currently no smartsheet function equivalent to the OFFSET function in Excel. (But it would be REALLY nice if there was one!) Until that particular enhancement request is finally achieved...I need help finding a workaround. My situation: I have a sheet of data where the columns contain individual employee…
-
Formula: Not in the last (x) days
Hi, What formula gives me the same value as the above filter? Would need something like COUNT IF {Range 1} Is Not in the last (x) days Thank you!
-
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