-
Formula for Summary of Total Tasks and Completed Tasks
There is a smartsheet template set in the solution center called New Employee Onboarding. In the sheet "30 Day Employee Onboarding Sheet" the tasks are organized by Week and By Day. The formulas for counting Completed: # of # are working for each day, but the Cells that have a Weekly Total are not summarizing for the week,…
-
Match Formula with another sheet
I am having difficulty with this formula that I would appreciate some assistance. I have a sheet with user names. If the user name matches that of a user name in another sheet, I need to select the checkbox. I have a column with a checkbox and the following formula: =IF(MATCH(Name1, {2019-01-11 IS Bi-Weekly Report Range…
-
Current w/c date
I need a formula that will return the date of Monday for the current week. So on Monday 08/05/2017 it will show 08/05/2017, but on Wednesday 10/05/2017 it will still show 08/05/2017. Please help!
-
% Complete is Not Working
Hello, I have a spreadsheet with about 85 tasks and subtasks, the % Complete isn't working. It's show the percent completed as 99%, when only about 10 tasks have been completed for this project. I tried to disable the Dependency Settings and use the =AVG(CHILDREN()) formula but then I got the divide by 0 error. So then I…
-
vlookup w/ resources and dates
We are working on a manpower tracking sheet and trying to create a link from one spreadsheet to another, which will lookup a resource and then find the latest date that resource has tied to it. This will allow us to see when we have someone coming off a project and has not been assigned to another project (on the bench).…
-
Importing Task Hierarchy from CSV file
We are looking to establish a daily import of our project portfolio into SS via a CSV file. When I look at the task import schema, I cannot see a way for SS to identify the parent and child relationships between the tasks. This means we cannot import nested tasks and the task hierarchy. Do you know if there is a field and…
-
Countifs with with percentages
What am I doing wrong? The formula was fine when I did the tower in air dates from today - 12.31.19, but as soon as I tried to add the condition of lease probability being above 49% it doesn't work. Any thoughts are greatly appreciated! =COUNTIFS({C. *Ground Lease Tower In Air Date}, >=TODAY(), {C. *Ground Lease Tower In…
-
Sumifs cross reference multiple criteria
Hello, I have a sheet where I am trying to reference multiple criteria from another sheet. For example I am looking for a count of Patient Fall with Injuries from a specific site. My formula is coming up as an incorrect argument. Any ideas on what I am doing wrong? =SUMIFS({AOD Master Patient Care Events template Range 3},…
-
Formula Issue
Hi all, would anyone let me know of any 'string' limitations in smart sheets when creating a formula? I have attempted the below in every conceivable possible way and I can only think that the formula is technically too long. I am trying to complete the below: * GDI End date before today and complete <> 100% * OR * GDHV…
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
