Smartsheet Behaviours
I am trying to create a form that throws back a response when you tick a box like the example below. I have been told to use the logic but i cant seem to find a logic that will work, any suggestions?
Additionally, if they tick an answer and it is incorrect, I want to show the text in red and if correct the text is in green. Does anyone know if this can be done?
Best Answer
-
Paul Newcome ✭✭✭✭✭✭You would have to insert a new header field into the form that has that particular verbiage formatted the way you want then use the form field logic to display this header row if one of the incorrect answers is selected.
Answers
-
Paul Newcome ✭✭✭✭✭✭
You would have to insert a new header field into the form that has that particular verbiage formatted the way you want then use the form field logic to display this header row if one of the incorrect answers is selected.
-
Julieh ✭
thank you that will work
-
Paul Newcome ✭✭✭✭✭✭
-
Julieh ✭
The only thing is it brings the result to the bottom of the question selections, do you know if there is a way to show the result after the question?
-
Paul Newcome ✭✭✭✭✭✭
There is no way to get it nested within the responses unless you make each response its own column.
Help Article Resources
Categories
If \"Yesterday\" and \"Today\" are the only text values you end up with, then this formula would do what you're after:<\/p>
=IF([Last Updated]@row = \"Yesterday\", TODAY(-1), IF([Last Updated]@row = \"Today\", TODAY(), [Last Updated]@row))<\/p>
Ironically, typing Yesterday\/Today directly into a date column in Smartsheet will give the relevant date (as will last\/previous\/next <insert day>) but I don't know if the Jira integration would support that or you'd need to use a helper column with the formula as above.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"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":[]},{"discussionID":108819,"type":"question","name":"Fill in a cell based on another cell's value?","excerpt":"Hello, I'm tracking participation of a program on my sheet as a \"participation %\" column. There is another column called \"participation status\" to make it easy for the managers to know if their employee is on track with participation or not. I'm trying to set up the participation status column so that if the participation…","snippet":"Hello, I'm tracking participation of a program on my sheet as a \"participation %\" column. There is another column called \"participation status\" to make it easy for the managers to…","categoryID":322,"dateInserted":"2023-08-10T20:29:21+00:00","dateUpdated":null,"dateLastComment":"2023-08-10T21:09:33+00:00","insertUserID":164943,"insertUser":{"userID":164943,"name":"ciera_wolinski","url":"https:\/\/community.smartsheet.com\/profile\/ciera_wolinski","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zB8mc3uvxuo!pXcnKVOwqro!qMp2YpGJXFb","dateLastActive":"2023-08-10T21:06:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":164943,"lastUser":{"userID":164943,"name":"ciera_wolinski","url":"https:\/\/community.smartsheet.com\/profile\/ciera_wolinski","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zB8mc3uvxuo!pXcnKVOwqro!qMp2YpGJXFb","dateLastActive":"2023-08-10T21:06:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":46,"score":null,"hot":3383402334,"url":"https:\/\/community.smartsheet.com\/discussion\/108819\/fill-in-a-cell-based-on-another-cells-value","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108819\/fill-in-a-cell-based-on-another-cells-value","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":108819,"commentID":390127,"name":"Re: Fill in a cell based on another cell's value?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/390127#Comment_390127","dateInserted":"2023-08-10T21:09:33+00:00","insertUserID":164943,"insertUser":{"userID":164943,"name":"ciera_wolinski","url":"https:\/\/community.smartsheet.com\/profile\/ciera_wolinski","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zB8mc3uvxuo!pXcnKVOwqro!qMp2YpGJXFb","dateLastActive":"2023-08-10T21:06:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-10T21:09:38+00:00","dateAnswered":"2023-08-10T20:58:08+00:00","acceptedAnswers":[{"commentID":390125,"body":"
=SUMIFS([Actual Charges]2:[Actual Charges]60, [SOW Reference]2:[SOW Reference]60, \"IPO PMO\")<\/p>
