欢迎来到Smartsheet论坛档案


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

是否真的没有内置的日志\NL功能?

迈克尔。贝克
迈克尔。贝克 ✭
编辑12/09/19 在2017年帖子

我和我的团队正试图在智能表格中实现我们的升级算法，但似乎SS不能用公式计算自然对数。我们是不是遗漏了什么?为什么党卫军的数学图书馆这么低能?

下面是我们正在尝试迁移的Excel公式。

=综述(LN (A2) / 1.609437912, 0) + 1

WHERE: A2是用户输入字段，表示受问题影响的用户数量。

显然，你可以用一堆嵌套的if语句来做一些事情，但这将是一团乱。

标签:
· 在Facebook上分享 在推特上分享

评论

这次讨论已经结束。

类别

It's not possible to include the date in the column, but here's a workaround:<\/p>
\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

<\/p>


<\/p>


<\/p>


<\/p>


<\/p>


<\/p>


<\/p>

\n \n https:\/\/help.smartsheet.com\/articles\/2482475-latest-comment-column\n <\/a>\n<\/div>


<\/p>

Julie Fortney<\/p>

www.linkedin.com\/in\/JulieFortney-PMP-SmartsheetPartner-LSSBlackBelt<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-30 19:10:44","updateUser":{"userID":156373,"name":"Alegna","url":"https:\/\/community.smartsheet.com\/profile\/Alegna","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-30T19:10:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"}]},{"discussionID":99117,"type":"question","name":"Index Collect value based on a date","excerpt":"I want to index a value if the \"This Sheet Date\" on my final result sheet is greater than \"Date Value Effective\" on my database sheet. Screenshots should help. I have a column showing the value that I want it to return. It's showing me the 2% because technically all of the \"This Sheet Dates\" are greater than the \"Date…","categoryID":322,"dateInserted":"2022-12-29T03:52:08+00:00","dateUpdated":null,"dateLastComment":"2022-12-30T17:31:50+00:00","insertUserID":139118,"insertUser":{"userID":139118,"name":"Kayla","url":"https:\/\/community.smartsheet.com\/profile\/Kayla","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4jS9-j6AyQ!-s9Rt9CEFHw!9QXda4h64Go","dateLastActive":"2022-12-30T15:05:51+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":"2022-12-30T17:37:42+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":57,"score":null,"hot":3344713438,"url":"https:\/\/community.smartsheet.com\/discussion\/99117\/index-collect-value-based-on-a-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99117\/index-collect-value-based-on-a-date","format":"Rich","tagIDs":[219,254,285],"lastPost":{"discussionID":99117,"commentID":355598,"name":"Re: Index Collect value based on a date","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355598#Comment_355598","dateInserted":"2022-12-30T17:31:50+00:00","insertUserID":45516,"insertUser":{"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":"2022-12-30T17:37:42+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\/VDS9I1DFG3H4\/database-log-changes.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Database Log Changes.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-30T15:09:14+00:00","dateAnswered":"2022-12-29T20:57:42+00:00","acceptedAnswers":[{"commentID":355559,"body":"

Give something like this a try...<\/p>

=IFERROR(INDEX(COLLECT({Value}, {Manager}, @cell = [Employee Manager]@row), COUNTIFS({Date}, @cell<= [This Sheet Date]@row, {Manager}, @cell = [Employee Manager]@row)), \"//www.santa-greenland.com/community/discussion/12231/\")<\/p>


<\/p>

Since the reference sheet is being fed via copy row automation, we want to assume that all entries will be in chronological order from top to bottom with new entries going at the bottom of the sheet (so we don't have to actually interact with the reference sheet).<\/p>


<\/p>

So what we do is COLLECT all of the {Value} where the {Manager} is what we are looking for. We then INDEX this list of values, and counting how many dates (for that manager) are less than or equal to the sheet date should give us the entry number from the COLLECT function to pull.<\/p>


<\/p>

Example: <\/p>

We COLLECT all of the values where the manager is John Smith. This gives us a list with 3 entries on it.<\/p>

The date on the formula sheet is 06 December 2022. This means our COUNTIFS is going to output the number 2 which tells the INDEX function to pull the second entry from our list generated by the COLLECT function.<\/p>


<\/p>

I haven't had any coffee yet today. The explanation may not make much sense, but the formula should work for you. If you need clarification on anything, please don't hesitate, and I will try to explain a different way (after I have had some coffee).<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-30 15:09:14","updateUser":{"userID":139118,"name":"Kayla","url":"https:\/\/community.smartsheet.com\/profile\/Kayla","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!w4jS9-j6AyQ!-s9Rt9CEFHw!9QXda4h64Go","dateLastActive":"2022-12-30T15:05:51+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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":285,"urlcode":"Solution Center","name":"Solution Center"}]},{"discussionID":99135,"type":"question","name":"Want a copy of automated email \"Send to contacts in a cell\"","excerpt":"Happy early 2023! I've created an automated workflow to send a message to \"Send to Contacts in a cell\" but I'd also like to be copied so I know when requestors are receiving it. How can I do this? Or is there a way to tell \"who\" was sent the automated email? Currently it would only tell you when the automation was last…","categoryID":321,"dateInserted":"2022-12-29T18:05:05+00:00","dateUpdated":null,"dateLastComment":"2022-12-29T19:35:26+00:00","insertUserID":145367,"insertUser":{"userID":145367,"name":"Sancta Watley","url":"https:\/\/community.smartsheet.com\/profile\/Sancta%20Watley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bYtrW4PMU_M!u0K05_U4mQg!GbzlM30r8OV","dateLastActive":"2022-12-29T19:32:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":145367,"lastUser":{"userID":145367,"name":"Sancta Watley","url":"https:\/\/community.smartsheet.com\/profile\/Sancta%20Watley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bYtrW4PMU_M!u0K05_U4mQg!GbzlM30r8OV","dateLastActive":"2022-12-29T19:32:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":37,"score":null,"hot":3344682631,"url":"https:\/\/community.smartsheet.com\/discussion\/99135\/want-a-copy-of-automated-email-send-to-contacts-in-a-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/99135\/want-a-copy-of-automated-email-send-to-contacts-in-a-cell","format":"Rich","tagIDs":[448],"lastPost":{"discussionID":99135,"commentID":355541,"name":"Re: Want a copy of automated email \"Send to contacts in a cell\"","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/355541#Comment_355541","dateInserted":"2022-12-29T19:35:26+00:00","insertUserID":145367,"insertUser":{"userID":145367,"name":"Sancta Watley","url":"https:\/\/community.smartsheet.com\/profile\/Sancta%20Watley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bYtrW4PMU_M!u0K05_U4mQg!GbzlM30r8OV","dateLastActive":"2022-12-29T19:32:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-12-29T18:26:11+00:00","dateAnswered":"2022-12-29T18:19:01+00:00","acceptedAnswers":[{"commentID":355518,"body":"

@Sancta Watley<\/a> <\/p>

Set up your trigger in the Automation and then set up 2 actions like this:<\/p>

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

For the bottom one, you'll select yourself as the specific person. You can edit the message to include the Contact column so when you receive the message you'll even know who the first alert went to.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question","log":{"dateUpdated":"2022-12-29 18:26:11","updateUser":{"userID":145367,"name":"Sancta Watley","url":"https:\/\/community.smartsheet.com\/profile\/Sancta%20Watley","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!bYtrW4PMU_M!u0K05_U4mQg!GbzlM30r8OV","dateLastActive":"2022-12-29T19:32:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"}}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]}],"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">