-
Data shuttle adding new rows far below existing rows
I'm having a weird problem with a data shuttle that previously worked flawlessly. I have a sheet which includes about 150 rows of information. I run a weekly data shuttle to add/update rows to the sheet. The data source for the shuttle is an Excel file. New data rows are added to the end of the sheet in the next available…
-
Salesforce Integration What does it actually do?
Hi All, I'm often surprised by how difficult it is to figure out what integrations actually do with the Salesforce. I was intending to make a case for the integration to our leads but I can't find a clear explanation of what it does on the website or searching. For instance could I: Have an automated contact in Smartsheet…
-
Changing Status Dot Color Based On Deadline Column
Hi, I've tried looking up other questions to answer this and got as far as this formula [=IF(Deadline@row <= TODAY(+14), "Green", IF(Deadline@row <= TODAY(+7), "Yellow", IF(Deadline@row >= TODAY(0), "Red", "")))], but it's not providing the proper results. I have a Deadline column and a Status column (which is the RGY…
-
Alternate for MAXIFS function
I have a scenario where in my smartsheet I have data for timesheet numbers for 12 months with multiple rows for a single user, I just want to use the latest set of records for all months and if any month has empty cell, then I want to pick up the previous record which has data for that cell, Possible ? In Image 1 I have…
-
Need help with Formula
Here is my formula to track Corrective Action status based on total attendance points. =IF([Total attendance points]@row > 7.9, "TERM", IF([Total attendance points]@row > 5.9, "FINAL", IF([Total attendance points]@row > 3.4, "WRITTEN", IF([Total attendance points]@row > 1.9, "VERBAL", IF([Total attendance points]@row <…
-
Formula Question
This is my current formula that is producing error - Unparseable, I can't seem to figure out what the issue is. =OR(IF(INDEX({Min_Skill_LTT}, MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}, 0)) = ([LTT Matrix Use]@row - 1,{Min_Skill_LTT}),"True", "False"),(IF(INDEX(MATCH([Job TItle]@row, {Minimum Skill…
-
Help with Index/Match & Vlookup
I need to create a parent row that shows a rollup view of budget for all of the children, but I don't want to add another row/line item to my Master Sheet with the parent row because it will get too complicated. Instead, I'd like to create a separate sheet with the Unique ID tied to each project category, and create an…
-
Date from a Cross-sheet formula not converting to a Date when row is moved #Invalid Type Error
I have a cross-sheet formula that adds the published date to my row. Once all the criteria are meet the row is then a workflow moves that row to the archive. But it doesn't seem to retain the Date designation once it has been moved. I was having issues with a countifs formula that was looking into the archives for items…
-
How to create a FX Column
I am using the template Invoice Receiving & Routing Management to create a new tracker. The first column is an FX column but this column isn't referenced in the sheet summary. How do you create an FX column? How do I adjust the formula in an FX column?
-
I need to separate out digits between characters (_) into a different column. Can this be done?
Hi there … I need to separate digits from between characters (_) into a separate column. 100936_BLK_IE_JUL_20240718231356_24_HI_REGULAR_4.ps 100936_BLK_IE_JUL_240718231626_6_HI_REGULAR_6.ps I need returned 24 and 6 from the strings above. Since there are multiple _ I'm not sure how to tell the formula to pull the digits…
