-
How to not show "O" results
So I used the formula below to count the courses in my helper field Course Count. I don't want to see the "zeros" in fields that are empty. So, how do I fix that? =COUNTIF(Courses@row, HAS(@cell, "Wound")) + COUNTIF(Courses@row, HAS(@cell, "ostomy")) + COUNTIF(Courses@row, HAS(@cell, "continence"))
-
Automating Due dates
I have a sheet that has an "activity" column. Each parent line has ~15 child line subtasks that make up the "Activity" column. I need to Automate due dates for each activity. Work flows don't seem to work because they will only record that days date. I'm not sure if using a formula will work since I need different due…
-
How to auto-populate my companies Fiscal Year week number if its a 52 week year?
My companies FY starts 8/1 and ends 7/30. Currently I am using =ROUND(((Created@row - DATE(2021, 8, 1)) / 7) + 0.49, 0) which works perfectly but it shows 56 weeks instead of a 52 week FY.
-
Creating an Outline value
I am trying to create an Excel export from my SmartSheet project plan for the purposes of importing select tasks into an internal PPM solution. One issue I have is the lack of an Outline field, just like we have in MSProject. Has anyone tried and succeeded to create a column within SmartSheet that can automatically create…
-
I'm just stumped on this date function. Can someone help me please?
I have a sheet that is tracking projects for our team. I have one column that is "Asset Due Date" and I want another column "TD Due Date" to auto populate a date that is 28 days prior to the date chosen for "Asset Due Date". Both columns are set up as date column types. I've played with the date function and just can't…
-
Issues with multiple Sumifs statements
I can't get this formula to work...any thoughts? =SUMIFS([Hours/Week]:[Hours/Week],[X Project Status]:[X Project Status], "Active", [Assigned to]:[Assigned to], "Employee Name", Type:Type, <>"Admin") + SUMIFS([Hours/Week]:[Hours/Week],[Y Project Status]:[Y Project Status], "Active", [Assigned to]:[Assigned to], "Employee…
-
Calculating Day Open from Original Date
Dear Mike, I have tried using your formula =networkdays([Date Column Title]@row, Today()) and I cant get this to work. I want to know how may days a job has been open from TODAY() and this to be refreshed everyday. I am using DATE2 as the created date has time included, and I dont need the time.
-
Looking for formula to have auto numbers, that subtasks inherit the main task job number
Hello, I am looking for an auto number formula that will have subtasks created in card view auto inherit the parent's job number for every card created. My workplace has a very old sheet that I believe does this but in grid mode and I am not sure how to re-create the effect. The column is a text/number format instead of…
-
Flag duplicates with conflicting dates
Hi, I have a list of names with a starting date and a finishing date. I am trying to get a formula that flags conflicting dates for the same person (duplicate). On excel I sorted with a SUMPRODUCT that I know smartsheet does not support. I have also tried to break it down so it adjust to smartsheet but I can't solve the…
-
JOIN function in INDEX/MATCH
Hello, I just found the join formula but when i use it my index and match stopped working on another sheet... is there a work around?