Legal

\"Approved\", @cell <> \"Rejected\", @cell <> \"Withdrawn\")) However everything…","categoryID":322,"dateInserted":"2019-03-15T11:52:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-15T14:32:06+00:00","insertUserID":75766,"insertUser":{"userID":75766,"name":"Karrie Davis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Karrie%20Davis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/QK72Y4JY5UIX\/n294YLQHLLQO2.jpg","dateLastActive":"2023-06-06T17:54:35+00:00","banned":0,"punished":0,"private":false,"label":"Overachievers"},"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-06-12T15:52:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":89,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/43706\/countifs-same-column-different-criteria","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43706\/countifs-same-column-different-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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"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":43456,"type":"discussion","name":"NETDAYS based on IF statement","excerpt":"I'm trying to use a NETDAYS function to determine how many days overdue a payment is, but I only want to display that number of days if a column named 'Status' has the value 'Client payment pending'. The function I'm trying to use is =NETDAYS([Date Sent to AP\/CR]398, TODAY()) but I don't know how to work that into a…","categoryID":322,"dateInserted":"2019-03-13T11:13:54+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-03-13T14:18:44+00:00","insertUserID":81681,"insertUser":{"userID":81681,"name":"SD@HL","url":"https:\/\/community.smartsheet.com\/profile\/SD%40HL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bBPX272FRz4!BFlXAbGyKbw!5CAD_Q514bi","dateLastActive":"2023-04-25T19:18:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":81681,"lastUser":{"userID":81681,"name":"SD@HL","url":"https:\/\/community.smartsheet.com\/profile\/SD%40HL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bBPX272FRz4!BFlXAbGyKbw!5CAD_Q514bi","dateLastActive":"2023-04-25T19:18:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":430,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/43456\/netdays-based-on-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/43456\/netdays-based-on-if-statement","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":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":274,"urlcode":"Legal","name":"Legal"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Coping Dashboard
Is there a way to copy or save a dashboard as a template. Instead of having to make new ones from scratch?
t恤尺寸为视觉图标图标吗?
Would love to have S/M/L T-shirt icons to visually look at sizing. This would be helpful as a project manager and on a scrum team
佛rmula Needed for Parent to Inherit Child Value
I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below. I use the "No Active Projects" marker to determine whether or not that department…
Sum ifs 3 criteria
I'm looking for the sumifs= Status column is "green", The Trans Date column in January 2018 the reversed column is unchecked. So far I only have the first part of the formula working. I cannot figure out how to include the rest =SUMIF({Collections Range 3}, @cell = "Green", {Collections Range 1}) This information will be…
If forumula
I trying to write a formula if (Days)<=30 will display an Amount in column 0-30
佛rms
I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would…
At Risk Report with parent and only some select rows
Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.
Clean up Sumif Formula
I have this formula to give me the sumif for multiple criteria I was just wondering if there is a simpler formula =SUMIF({Healtcare Range 3}, @cell = "Memberships", {Healtcare Range 2}) + SUMIF({Healtcare Range 3}, @cell = "Sponsorships", {Healtcare Range 2}) + SUMIF({Healtcare Range 3}, @cell = "Client Seminars / Events",…
Countifs same column different criteria
Hi I'm trying to count the items in the in one column if they are not equal to criteria in another column. May someone assist. This is what I have so far. =COUNTIFS({FDA Submission 2019 Range 1}, "DE Novo", {FDA Submission 2019 Range 2}, OR(@cell <> "Approved", @cell <> "Rejected", @cell <> "Withdrawn")) However everything…
NETDAYS based on IF statement
I'm trying to use a NETDAYS function to determine how many days overdue a payment is, but I only want to display that number of days if a column named 'Status' has the value 'Client payment pending'. The function I'm trying to use is =NETDAYS([Date Sent to AP/CR]398, TODAY()) but I don't know how to work that into a…

Legal

Discussion List