欢迎来到Smartsheet论坛档案


本论坛中的帖子不再被监控准确性，其内容可能不再是最新的。如果这里有您感兴趣的讨论，并且您想找到(或创建)一个更最新的版本，请访问当前论坛。

2017年帖子

讨论表

类别

受欢迎的标签

Hi @Czarmaine Quemuel<\/a>,<\/p>

Try this:<\/p>

=NETWORKDAYS(C2, TODAY())<\/p>

This will exclude weekends as well as any holidays you have defined in your Project Settings. Remember you can access your Project Settings by right-clicking a column header, and selecting \"Edit Project Settings\". Dependencies must be enabled there first, and then you can select which days of the week are in-scope as well as exclude holidays (dates) by listing them, comma-separated, in the space provided.<\/p>

Hope this helps!<\/p>

BRgds,<\/p>

-Ray<\/p>"},{"commentID":354059,"body":"

Hi @Czarmaine Quemuel<\/a>,<\/p>

Is your C2 date in the future?? If so, that's what is causing it.<\/p>

If not, here are a couple things to try:<\/p>

=ABS(NETWORKDAYS(C2, TODAY()))<\/p>

=NETWORKDAYS(TODAY(), C2)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-12 21:33:29","updateUser":{"userID":152231,"name":"Czarmaine Quemuel","url":"https:\/\/community.smartsheet.com\/profile\/Czarmaine%20Quemuel","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/ALm5wu3AD5umJ_yzm7yLgYzSEIE5UBPLdvQWSQH3SRLx=s96-c","dateLastActive":"2022-12-12T21:52:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]},{"discussionID":98671,"type":"question","name":"Multiplication formula","excerpt":"I need help multiplying two columns. One is a formula equaling a percentage, the other is the value of another column that is adding multiple columns together. I keep getting in invalid value error. Colum - Probability - with the percentage looks like this: Column - Total Software TCV - with the value that needs to be…","categoryID":322,"dateInserted":"2022-12-12T19:15:41+00:00","dateUpdated":"2022-12-12T19:17:52+00:00","dateLastComment":"2022-12-12T23:06:18+00:00","insertUserID":121449,"insertUser":{"userID":121449,"name":"Stacy Stoffel","url":"https:\/\/community.smartsheet.com\/profile\/Stacy%20Stoffel","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1_UYX3MIP4!pV1WKUHFqiQ!qlWJLt5u46b","dateLastActive":"2022-12-12T22:54:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":121449,"lastUserID":121449,"lastUser":{"userID":121449,"name":"Stacy Stoffel","url":"https:\/\/community.smartsheet.com\/profile\/Stacy%20Stoffel","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1_UYX3MIP4!pV1WKUHFqiQ!qlWJLt5u46b","dateLastActive":"2022-12-12T22:54:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":3341760119,"url":"https:\/\/community.smartsheet.com\/discussion\/98671\/multiplication-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98671\/multiplication-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":98671,"commentID":354090,"name":"Re: Multiplication formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354090#Comment_354090","dateInserted":"2022-12-12T23:06:18+00:00","insertUserID":121449,"insertUser":{"userID":121449,"name":"Stacy Stoffel","url":"https:\/\/community.smartsheet.com\/profile\/Stacy%20Stoffel","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1_UYX3MIP4!pV1WKUHFqiQ!qlWJLt5u46b","dateLastActive":"2022-12-12T22:54:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/QACNKYC08B6S\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-12T22:54:31+00:00","dateAnswered":"2022-12-12T21:05:23+00:00","acceptedAnswers":[{"commentID":354050,"body":"

Hi @Stacy Stoffel<\/a>,<\/p>

In your Colum - Probability column, I notice you're using \"25%\" when assigning a value if the logical condition is True. Try removing the \"//www.santa-greenland.com/community/categories/c2017/\" around the 25%.<\/p>

You can instead assign either 25% or .25 in it's place. Do this for each percentage you're trying to assign in that formula.<\/p>

Then a simple =[Probability %]@row * [Software TCV]@row <\/p>

should work for you in your Column - Weighted TCV (Software TCV * Probability) column.<\/p>

If wrapped with the VALUE formula, my testing resulted in the same. If that's the case, stick with the simpler formula above.<\/p>

=VALUE([Probability %]@row) * [Software TCV]@row <\/p>

Hope this helps!<\/p>

BRgds,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-12 22:54:31","updateUser":{"userID":121449,"name":"Stacy Stoffel","url":"https:\/\/community.smartsheet.com\/profile\/Stacy%20Stoffel","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1_UYX3MIP4!pV1WKUHFqiQ!qlWJLt5u46b","dateLastActive":"2022-12-12T22:54:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":98667,"type":"question","name":"Date or N\/A in a cell","excerpt":"I am trying to figure out a column formula that will auto-populate a cell with either a date or an N\/A: N\/A, if the [TOTAL BUDGET] cell is under $100,000 or =[Final Report Due]@row + 15 if the [TOTAL BUDGET] cell@row is $100,000 or more (this would be the audit report due date) I tried this but it's not quite working:…","categoryID":322,"dateInserted":"2022-12-12T16:29:51+00:00","dateUpdated":"2022-12-12T16:57:17+00:00","dateLastComment":"2022-12-12T17:01:03+00:00","insertUserID":153339,"insertUser":{"userID":153339,"name":"LizTo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LizTo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2CQCCYN0E8TB\/nGSDCLO1LATU6.jpg","dateLastActive":"2022-12-12T17:15:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":153339,"lastUserID":153339,"lastUser":{"userID":153339,"name":"LizTo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LizTo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2CQCCYN0E8TB\/nGSDCLO1LATU6.jpg","dateLastActive":"2022-12-12T17:15:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":32,"score":null,"hot":3341728254,"url":"https:\/\/community.smartsheet.com\/discussion\/98667\/date-or-n-a-in-a-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/98667\/date-or-n-a-in-a-cell","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":98667,"commentID":354025,"name":"Re: Date or N\/A in a cell","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354025#Comment_354025","dateInserted":"2022-12-12T17:01:03+00:00","insertUserID":153339,"insertUser":{"userID":153339,"name":"LizTo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LizTo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2CQCCYN0E8TB\/nGSDCLO1LATU6.jpg","dateLastActive":"2022-12-12T17:15:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-12T16:59:52+00:00","dateAnswered":"2022-12-12T16:57:20+00:00","acceptedAnswers":[{"commentID":354024,"body":"

Hi @LizTo<\/a>,<\/p>

=IF([TOTAL BUDGET]@row < 100000, [Final Report Due]@row + 15, \"N\/A\")<\/p>

Ensure the column you're calculating in is a Date column, but not restricted to Date values which allows for the \"N\/A\".<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

All the best,<\/p>

-Ray<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-12 16:59:52","updateUser":{"userID":153339,"name":"LizTo","title":"","url":"https:\/\/community.smartsheet.com\/profile\/LizTo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2CQCCYN0E8TB\/nGSDCLO1LATU6.jpg","dateLastActive":"2022-12-12T17:15:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"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}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">