Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Archived 2016 Posts

Finding Duplicates
Hello, I have several sheets. One every month with at least 2000 rows per month. I import the information from an outside source via Excel. Long story short, there is a high probably ability of getting duplicate information from the outside source. Once imported from Excel into Smartsheet is there a way to fnd & delete…
Formula for when if a checkbox is checked...or not
What would be the formula that would return "True" if a checkbox is marcked as checked and "False" if it is not? Thank you!
Gantt scheduling of holidays
If holidays are entered in the "Non-Working Days", will there be visible evidence in the Gantt chart to reflect this?
Make Collapse ALL default
I have clients with indented children. Everytime I come to the sheet the children are fully expanded. How do I make Collapse ALL the default setting? Matters not if I save it as collapsed.
Row Height
Is there a way to shrink row height, even if the font size does not want to allow? This is possible in MS Excel, even if lower parts of letters (like y, g, etc) are slightly cut off.
Feature Request: JOIN() carriage return separator
I would like to JOIN() to allow the carriage return as a separator. This would allow me to transpose the data. JOIN([Column1]23:[Column12]23,"\n") would take the row and give me a cell with the contents transposed vertically. JOIN([Column1]1:[Column1]22," ") would take the column and give me a cell with the contents…
Freeze row or rows at top of sheet or column info mouse-over
Since the column header are fairly limited in max length, it would be nice to be able to add some info on the column purpose to either a row that has been frozen (does not scroll with rest of sheet), or to a mouse over field. Is there any plans for such a feature. Kind of surprised it isn't already in place. Maybe I am…
Formula to determine row number
Hello, I am wondering if there is a way to determine the row number of a specific row. I know this can be done in Excel with the row() function. This does not work in Smartsheet. The reason I am looking for it is because I have a formula that needs to apply to every row that checks the row above it, but that fails when it…
Report Developing - Removing "Header" task
Hello all, I am trying to see if there is a way to remove those "header" tasks from reports. I ask this because it captures dates from the sub tasks and therefore becomes duplicative in a report. I have colored these lines so its easy to overlook them now but it would be lovely to have a way to remove them completely. For…
How to use end date and percentage complete to automate RYG status
Hi everyone, Maybe my brain is struggling with IF and AND statements, but this is defeating me. I am trying to use the end date of a task compared to today's date and the percentage complete (great than or equal to 75%) to drive my status column of red, yellow, green balls. I think I need to find a way to combine the…

Popular Tags

Hey @decrom<\/a> <\/p>

Try this and see if it produces the expected result. Please be sure to test one 'In Process' with ZERO 'Untrained'. Was this what you expected?<\/p>

=IF(COUNT(CHILDREN(Proficiency@row)) > 0, IF(COUNT(CHILDREN(Proficiency@row)) = COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\"), \"Untrained\", IF(AND(COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\") >= 1, COUNT(CHILDREN(Proficiency@row)) > COUNTIFS(CHILDREN(Proficiency@row), \"Untrained\")), \"In Progress\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"In Process\") >= 1, \"In Process\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Trained\") >= 1, \"Trained\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Proficient\") >= 1, \"Proficient\", IF(COUNTIFS(CHILDREN(Proficiency@row), \"Preceptor\") >= 1, \"Preceptor\")))))))<\/p>

Please let me know what we need to tweak<\/p>

Kelly<\/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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107651,"type":"question","name":"With Control Center, is the Global Update feature also able update automated workflows?","excerpt":"I used automated workflows... a lot. We're looking to purchase Control Center, but it is not clear to me if I will be able to update my automated workflows across multiple sheets in the event I have a common change or update to make.","snippet":"I used automated workflows... a lot. We're looking to purchase Control Center, but it is not clear to me if I will be able to update my automated workflows across multiple sheets…","categoryID":343,"dateInserted":"2023-07-16T00:18:56+00:00","dateUpdated":null,"dateLastComment":"2023-07-16T16:19:53+00:00","insertUserID":162134,"insertUser":{"userID":162134,"name":"CamSME","title":"Process Developer","url":"https:\/\/community.smartsheet.com\/profile\/CamSME","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/77LU8YZ28C58\/nJEEKOCCX2CP5.png","dateLastActive":"2023-07-16T17:07:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":122388,"lastUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-07-16T16:20:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":26,"score":null,"hot":3378992929,"url":"https:\/\/community.smartsheet.com\/discussion\/107651\/with-control-center-is-the-global-update-feature-also-able-update-automated-workflows","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107651\/with-control-center-is-the-global-update-feature-also-able-update-automated-workflows","format":"Rich","tagIDs":[466],"lastPost":{"discussionID":107651,"commentID":385483,"name":"Re: With Control Center, is the Global Update feature also able update automated workflows?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385483#Comment_385483","dateInserted":"2023-07-16T16:19:53+00:00","insertUserID":122388,"insertUser":{"userID":122388,"name":"Matt Johnson","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/ZX2A39HRG0VO\/nLJJDDQXUVD4H.JPG","dateLastActive":"2023-07-16T16:20:06+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":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-16T15:01:29+00:00","dateAnswered":"2023-07-16T14:48:33+00:00","acceptedAnswers":[{"commentID":385480,"body":"

Hi @CamSME<\/a> <\/p>

Unfortunately updating automated workflows is not a feature in Global Updates. If you can get around that though, Control Center can be really great.<\/p>

I hope that helps.<\/p>

Right. That was to be inserted in place of the COUNTIFS in your existing formula, but I did forget to add the date piece in.<\/p>

COUNTM(COLLECT([Product Sold]:[Product Sold], Agent:Agent, @cell = Agent@row, Date:Date, @cell = Date@row))<\/p>"},{"commentID":385417,"body":"

Bro! that was it! Thank you, I would not thought to use CountM(Collect for this at all. <\/p>

<\/p>

100% thank you!😁<\/span><\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">