-
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…
-
% 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:…
-
Count 1 row and get an average based on a score in another row
Hello, How can I use this function that I know in Excel, but in Smartsheet? =SUM(J1:J5)/COUNTA(I1:I5) J - column( scores ) = either a 1 or a blank cell I - column = customer service Thanks
-
Help with COUNTIF formula
I am trying to write a formula that will automatically fill in the checkbox IF another checkbox cell is also checked. Here is the current formula I am using. =IF(COUNTIF([Repair Doors Needed]:[Repair Doors Needed], [Repair Doors Needed]@row) > 1, 0, 1) The weird thing is, this formula works on some of my sheets, but…