Hello, I have a need to sort two columns, both ascending (works in Grid View) but that sort order is not staying for every column when I switch to card view. The business goal is to sort by workstatio…
Hello, Is there a way to add the comments section to a form? Or a formula to move / copy text from a comments column into the comments section? Thanks! Matt L.
Hello, I have a question: I set an automation for when the value of a cell equals 'Submitted' or 'Resubmitted' and where the value of 5 other cells say 'Approved' a check box should be checked. The au…
Hello, Is there a way to surface just the comments from a sheet into a dashboard? Right now I have a report where the comments are seen at the row level, which is a step in the right direction. The li…
Hello, I need to check a box in a parent cell only when all children cells in that column have been checked. I will manually paste this formula into multiple parent cells in my sheet. The formula I tr…
Hello, My question involves an Update Request . The process is this: we request an update from a contact in a cell. That contact receives an email with a custom message in the 'customize message' fiel…
Hello, I would like to have users enter data into a report, and not the underlying sheet or sheets. I know you can edit data in a report, but you cannot enter new data from the report view. Is this po…
Hello, I have 7 source sheets that I would like to use for a sheet summary report. Only one of the sheets is returning values to the report. All the sheets have the same 'Status' column, with the same…
Hello, I have one cell with two pieces of data separated by a / but not all cells have two two data points. I have a formula to separate out the data to the left and right of the / when there are two …
Hello Smartsheet people, I have a report that is pulling in all open tickets from a single source sheet, and I want the report displayed on a dashboard. I want this specific report to only show the ti…