AaronO✭✭✭

Comments

  • Bumping this as it bit me today. I fully understand that the "export to excel" is simply saving the numbers in the predecessors column, but what's the purpose of that? I can't really use it for anything - in my case, I want to process the exported file to perform some calculations, so I have to change the predecessor…
    inPredecessors shift by 1 when export to Excel Comment byAaronO 03/28/23
  • I should also note Shaine's question above: what are the drawbacks to changing the column type after import vs having an option to select the column type during import? It's a pain and it's confusing. I get that it's clever to do this interpretation, but the assumptions the tool is making (if a column is all 0, it must be…
    inBug: CSV import results in wrong column type Comment byAaronO 03/03/23
  • Wow, a five-year-old thread on this topic. This is terrible behavior. Maybe it's not a "bug" but the logic used to interpret column types is inscrutable. Consider this csv file: t1,t2,t3,t4 1,1,0,0.0 1,0,0,0.0 0,0,0,0.0 0,"hi",0,0.0 Importing this results in: Column t1 is a text/number column Column t2 is a checkbox column…
    inBug: CSV import results in wrong column type Comment byAaronO 03/03/23
  • Yes, this can be simulated by opening a new tab, pointing it to SmartSheet, and navigating to the second sheet, but what a pain! It's true that we'll never get the instant gratification of "something changes on sheet A and it's automatically, immediately updated on linked sheet B" that we get in a desktop spreadsheet, but…
    inOpen multiple sheets in a New Window/Tab option Comment byAaronO 03/03/23
  • Another use for this kind of thing, inspired by this question: This person wants a checkbox column that automatically checks a parent checkbox when all the children checkboxes are checked. A use for this is the "done" box in a card view - when all the subtasks are marked "done" have the parent task (optionally)…
    in"Rollup" column type Comment byAaronO 03/02/23
  • Strange - I see a different behavior: Using =IFERROR(Pad@row + Period@row, "Awaiting Possession") I get the error if they're both blank; if there's a [Period] but no [Pad] the result is a blank. In any case, would this work? It's a little brute-force-y but maybe more predicable... =IF(AND(NOT(ISBLANK(Pad@row)),…
    inIferror challenge Comment byAaronO 03/01/23
  • Great!
    inHow to flag the second largest date in a sheet Comment byAaronO 03/01/23
  • I think you can do just what you want. You can put formulas in dropdown columns as long as you have not restricted the column to dropdown items only. So in the "Purchasing Status" column at the 000 level you could put in a forumula like: =COUNTIF(children(),"Ordered") + " ordered" and see: You could do it a new column,…
    inHow to count Child Items based a dropdown list of criteria Comment byAaronO 03/01/23
  • Hi @Macorne, Hm. Are you sure the [Previous entry] column is a Date column? I get "Invalid Column Value" when I try to put a date into a text/number column and vice-versa. Since LARGE([Created]:[Created],2) produces a date, it needs to be in a Date column. Further, I am able to make the LARGE function work on the [Created]…
    inHow to flag the second largest date in a sheet Comment byAaronO 03/01/23
  • I'm not sure what you're trying to do. Is it "based on the start and end dates of a task, tell me how much revenue I can expect next week"? Is the % Complete something that you're filling in, or it's something you're calculating in order to come up with the revenue number? In other words, if I have a task that will take 30…
    inHow to switch forecast from monthly to weekly Comment byAaronO 02/28/23
Avatar