LakeWaconia✭

Comments

  • Thank you Devin! Your insights on the parenthesis helped me fix my formula. Posted here as comparison for anyone's future reference. =IF([Outsource Due Date]@row = "", IF([Route Number]@row = "FAB-WELD-NOFIN-09", WORKDAY([Assembly Start Date]@row, -4), IF(OR([Route Number]@row = "FAB-FIN-01", [Route Number]@row =…
    inNested IF OR limits? Comment byLakeWaconia 01/13/22
  • I'm having a very similar issue. I'm on a Pro Plan My client has an Enterprise Plan I'm trying to share a sheet with 4 collaborators at the client. They all have either Editor or Admin access on their plan. I've tried sharing the sheets with them both as Editors and Admin. The invitation and the sharing details shows up a…
    inPermissions not working correctly Comment byLakeWaconia 01/09/22
  • 我确切的年代ame issue. I'm only sharing with 4 users, all are on an Enterprise Plan at a different company. I have a Pro plan. I've reached out to Smartsheet and again, no response.
    inAccess Issues with Smartsheets? Comment byLakeWaconia 01/09/22
  • Thanks Paul there are only 5 collaborators on each item.
    inSharing Across Domains - Only get View Only Access Comment byLakeWaconia 01/08/22
  • Thanks Mark, I really appreciate the support. I still get an #UNPARSEABLE statement. At one time I thought for sure I had your original solution working, so I'm wondering if something else is messed up in my sheet? I've attached it for reference. See formulas in "Customer" column
    in@row referencing cell above Comment byLakeWaconia 11/19/21
  • Genevieve, Any ideas on if I wanted to collect those same items, but instead of joining them into one cell, listing them separately in cells, i.e. Row 1: 250P Row 2: 250PC Row 3: GT34BP etc....
    inCopy values from multiple columns if condition exists Comment byLakeWaconia 11/19/21
  • Genevieve, That worked absolutely perfect. Thank you so much!
    inCopy values from multiple columns if condition exists Comment byLakeWaconia 11/19/21
  • Mark and Kirstine, this is just what I've been looking for, however, I keep getting an #UNPARSEABLE response. I have the "LINE-ID" AND "ROW#" columns working fine, however whenever I add an "=INDEX([Customer],[ROW#]@row -1)" either by itself or within a longer formula, I get #UNPARSEABLE . Any ideas?
    in@row referencing cell above Comment byLakeWaconia 11/18/21
Default Avatar