mattstoc✭

Comments

  • Andree - as always thanks for the prompt response. Response 1 - Use WorkApps or "highest Advance package" - Those would likely work, but we have decided we are not willing to put additional money into premium apps/packages Response 2 - Dynamic View - This we have and are interested in wresting more value from it. I…
    inProtect Workspace Sheets From Being Copied Comment bymattstoc 10/20/22
  • I didn't know that and it is helpful. It is a step in the right direction, but I still believe a view/edit form that allows for placing fields where desired would be a great addition.
    in查看单个记录页面View Format Comment bymattstoc 06/17/22
  • Ok, we figured it out. Edit can edit cells (add formulas, etc). Admin is required to make a structural change to a sheet (insert column, rename, etc).
    inUnable to Insert Column Comment bymattstoc 06/16/22
  • Thank you for the quick reply. I have the data in a single sheet, so it is not a problem of gathering data. The thing I am trying to resolve is the visual layout of a single record of information. The options I appear to have in smartsheet: 1) Run a report with the columns I want in the order I want. Filter that to the…
    in查看单个记录页面View Format Comment bymattstoc 05/17/22
  • Andree, Thank you for the reply. That is the solution I came up with as well. The primary drawback is I put data that should reside in a single place (all the project data) in two separate places depending on who is using it. It is just not as logically clean. Have a great day.
    inSharing - Permissions by Subfolder or Workgroup Comment bymattstoc 03/03/22
  • Thank you both for the information. Julio - I was unaware of cell-linking and they maybe a workable solution, I need to play with it a bit and see. Andree - The control center looks very useful, I'm jut not quite ready to invest in a another premium tool. However, I may be as our portfolio grows.
    inCombine Info from Multiple Projects to a Report, pull status from Report to Sumamry Sheet Comment bymattstoc 01/26/22
  • This has been fun since I am learning smartsheet. I created a similar spreadsheet. The following formula works for me: =IF(AND([Global Lead]@row <> "EU", [Regional Startup Date]@row = ""), [Lead Startup Date]@row, [Regional Startup Date]@row) Notes: The result column is formatted as a date data type It looks like your…
    inIF/AND cross-sheet formula not working Comment bymattstoc 01/19/22
  • Here is the formula that I used (I recreated a similar sheet) =SUMIFS([WC Value]1:[WC Value]18, Parent1:Parent18, 1, [Producer(s)]1:[Producer(s)]18, "Kristina")
    inSUMIFS formula that includes a checkbox condition Comment bymattstoc 01/18/22
Default Avatar