I am attempting to create a few reference columns using an INDEX/COLLECT function and incorporating a MAX/COLLECT because there is a 1-Many relationship on the RTO Queue ID in the 2nd sheet so I would…
Hi Smartsheet Community, Please see image of setup! I am trying to create a column formula for the column 'TEST' that pulls the name of the Level 1 parent task for each row. Essentially, I want every …
I worked out this formula with someone during a ProDesk session but they weren't sure how to remove the commas when they weren't needed so I'm hoping someone else maybe has an idea! The formula: =JOIN…
Hello! I'm still a beginner smartsheets user, and while I am decent with excel the live updates is still very new. I'm trying to create a formula that will pull information on a weekly basis, M-F, tha…
I have countifs statement but then need to account for multi-value dropdown list and wonder the best way to capture the values. So counting projects status of in project - with a business value of 6 o…
Doing project roll up and trying to use the formula below to roll up a complete status. =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", "Not") However, blank cells do not contribu…
Hi All, I am attempting to write a formula that would check a box if a value is present in another sheet, and I can't figure out exactly how to write it. I am thinking it would be a combination of IF,…
Hello Experts, I have 3 COMMENTS row duplicated and 1st COMMENTS row is having translation captured for the 3 language headers. However, there is 2nd and 3rd COMMENTS row. I have already enabled dupli…
I need a formula that looks in multiple cells for a value, when it finds a value, do a lookup to find the translated value. I have a sheet that is gathering data in different languages, and we need th…
Adding a column formula is convenient, but there are times when the formula doesn't apply to everything listed on the sheet. It would be nice to be able to remove the formula just for that cell so it …