-
Is there a better way to send notification if a cell has no update?
I have a file with two workflows. The first workflow is an update request which is sent on Thursday's. The other workflow is to notify the owner if a cell was not updated as requested. To trigger this workflow I created the following helper columns: Modified: auto number with date formula Modified date: date only from the…
-
I need a formula to calculate projected hours based on start/finish dates
In a project plan we have start date, finish date, and an estimated hours column to track against budgets. I need to be able to identify and total projected hours needed by month. Formula should return and absolute 36 hours for December - populating 20 and 16 in Dec column, 28 hours for January - populating 8 and 20 hours…
-
Count ifs formula
Hello, I'm using a smartsheet to track contacts engaged in a multi-year project. I'm trying to count all the contacts engaged in year 1 AND 2 in a sheet summary report and can't figure out how to countifs for this sheet. My column is called "year Engaged" and my fields say either "grant cycle #1" or "grant cycle #2". This…
-
help with a formula
Hi All picking your brain here on formulas cant make it work, I am looking to count if: In my column A the name is DC380 and if corresponding at the value in column A, the value in column B and C is "not done", see an example below: DC status A Status B DC480 approved not done DC280 approved not done DC380 approved not…
-
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…