Formulas

=TODAY(), {C. *Ground Lease Tower In…","categoryID":322,"dateInserted":"2019-01-08T16:08:16+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-17T12:31:11+00:00","insertUserID":57851,"insertUser":{"userID":57851,"name":"KO_in_Colo","url":"https:\/\/community.smartsheet.com\/profile\/KO_in_Colo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-11T12:07:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":57851,"lastUser":{"userID":57851,"name":"KO_in_Colo","url":"https:\/\/community.smartsheet.com\/profile\/KO_in_Colo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-09-11T12:07:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":518,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/38576\/countifs-with-with-percentages","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/38576\/countifs-with-with-percentages","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":39181,"type":"discussion","name":"Sumifs cross reference multiple criteria","excerpt":"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},…","categoryID":322,"dateInserted":"2019-01-16T12:19:40+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-01-17T12:11:42+00:00","insertUserID":57856,"insertUser":{"userID":57856,"name":"jjanusz","url":"https:\/\/community.smartsheet.com\/profile\/jjanusz","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-01-16T17:42:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":8,"countViews":372,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/39181\/sumifs-cross-reference-multiple-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/39181\/sumifs-cross-reference-multiple-criteria","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"}],"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

SUMIF using a cell with a formula in it
OK, so my formula is this: =SUMIF([Customer PO]:[Customer PO], [Customer PO]2, [Value to be invoiced]:[Value to be invoiced]). I'm pretty sure it's correct, but the 'Customer PO" column uses a VLOOKUP formula which I think is what's causing a #NO MATCH error...? Is there any way to get around this?
Reference Entire Column in Function
Hello Team, I wish to reference an entire column in a function, for example: Current Function: =SUMIF([Task Owner]1:[Task Owner]82, "Text", [Resource Sum Column]1:[Resource Sum Column]82) / 100 Desired Function: =SUMIF([Task Owner]:[Task Owner], "Text", [Resource Sum Column]:[Resource Sum Column]) / 100 Is this possible? I…
公式总结啊f 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},…

Formulas

Discussion List