Finance

30,\"Red\",IF(AND(TODAY-[INVOICE DUE DATE]11>5,TODAY-[INVOICE DUE DATE]11<=30),\"Yellow\", IF(OR(TODAY-[INVOICE DUE…","categoryID":318,"dateInserted":"2016-08-19T06:58:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-19T16:38:59+00:00","insertUserID":7893,"insertUser":{"userID":7893,"name":"Ladislav","url":"https:\/\/community.smartsheet.com\/profile\/Ladislav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-19T16:31:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7893,"lastUser":{"userID":7893,"name":"Ladislav","url":"https:\/\/community.smartsheet.com\/profile\/Ladislav","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-19T16:31:30+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":89,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/5855\/nested-if-formula-using-additional-and-or-logical-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5855\/nested-if-formula-using-additional-and-or-logical-functions","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":271,"urlcode":"Services","name":"Services"}],"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":5780,"type":"discussion","name":"Advanced User Training","excerpt":"Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.","categoryID":318,"dateInserted":"2016-08-10T17:51:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-08-11T10:57:27+00:00","insertUserID":800,"insertUser":{"userID":800,"name":"Archie Lopez","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Archie%20Lopez","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-02\/6e\/d9\/n6ed9a535713114243c20137ccc5a4f4c.JPG","dateLastActive":"2023-06-08T15:22:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":234,"lastUser":{"userID":234,"name":"Stephen Branstetter","url":"https:\/\/community.smartsheet.com\/profile\/Stephen%20Branstetter","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/18\/9c\/n189cbca1a797d1528b418d7b428974d7.jpg","dateLastActive":"2021-05-10T15:51:58+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":24,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/5780\/advanced-user-training","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5780\/advanced-user-training","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":210,"urlcode":"Human Resources","name":"Human Resources"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":442,"urlcode":"groups-and-group-management","name":"Groups and Group Management"},{"tagID":444,"urlcode":"card-view","name":"Card View"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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}">

Printing Sight View
Is it possible to print a Sight view? I spent a long time setting up an attractive Sight pulling from a report and other data and now want to be able to print it. What are my options? By publishing it to a URL, will I be able to print the URL view? Thank you for any feedback!
Purchase Order Forms
I want to create a purchase order form that I can send to suppliers by email from SmartSheets and receive a confirmation form back by email that the order is accepted with delivery details. The purchase order will need an internal authorisation. A unique PO number. Entry into the Smart sheet on authorisation. Ideally the…
Help: Using =IF and Replace
Hello All, I need help making a formula that will replace a cell with Static Information with a pre-assigned phrase when the information present in a row's range (IE [Room Assignment]22:[Room Assignment]50) matches cell's information. I'm lost on how to make this happen, and hope the solution is simple. I have a limited…
CountIfs and Blanks, not blanks
Hi Guys I have two columns of data that I want to summarise with a count into a specific cell where the follpowing conditions are true: The first column is NOT blank AND the second column IS Blank. Not sure if CountIf's is right for this. Any help would be appreciated! All the best Barry
Name instead of email address of the person created the row
I used this "Auto-system - created by" column property and what appear in the column is the email address of the user who collaborator who created the row. Is there a way to changed it instead to the name of the user who created the cell. Thank you.
If/OR formula
I can't see where I went wrong; I am trying to get two columns to calculate the number of days between two dates when one of the fields is "N/A". Here's what I have so far: =IF(OR([Initial Approval]1="",[Request for PR]1="",[Initial Approval]1="N/A",[Request for PR]1="N/A"),=(NA(),[Request for PR]1-[Initial Approval]1+1)…
include TIME in the column properties
嗨,内容,是有可能的you to add Time column property?
New Comment Format Causing Confusion
We have been using the old Discussions feature for the last 3+ years as a way of entering unrelated notes on projects rather than as a way to send messages back and forth between users. The recent transition to Comments has made all our notes look like replies to previous notes when in fact they are totally unrelated. To…
Nested IF formula using additional AND/OR logical functions
Hello everybody, I am struggling with creation of formula for defining Invoice Status Symbol (RYG). Geeting the UNPEARSEABLE error message. My formula is right now as follows: =IF(TODAY-[INVOICE DUE DATE]11>30,"Red",IF(AND(TODAY-[INVOICE DUE DATE]11>5,TODAY-[INVOICE DUE DATE]11<=30),"Yellow", IF(OR(TODAY-[INVOICE DUE…
Advanced User Training
Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.

Finance

Discussion List