-
Rounding to nearest Thursday in the past or current day if it's Thursday
Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the current Thursday, if today is Thursday. In other words, the date should always display a Thursday date; if today == Thursday,…
-
Need a conditional SUMIFS formula
Hello, I have 2 grids Grid A: Project Management (used for team planning and communication) Screenshot of Grid A Grid B: Invoicing sheet (used for billing clients). I need a formula to take the information in Grid B and tell me the sum of the rows in the Task 1 column IF the sent column is checked AND the void column is…
-
Sheet history with deleted rows
When we synchronize a Smartsheet sheet with another application and delete a row, sometimes the row cannot be deleted in the other application due to business rules, and we must restore the row’s data. Additionally, sometimes when a row is deleted, we need to send specific data from a cell, but we no longer have access to…
-
Viewing a list of children as a list of checkboxes
In Card View you can see the children elements in each card, as you can see in the bellow image. This information is missing in the cards of the Board View and is very usefull.
-
View Parent on top of the card
Hi. In Card View you can see the parent element in each card, as you can see in the bellow image. This information is missing in the cards of the Board View and is very usefull.
-
Masking certain columns to viewers
Hi all, We have a main spreadsheet where we keep all of our projects including the budget for those projects. I would love an option where I can either share that spreadsheet, but mask certain columns or duplicate that spreadsheet, but not fill in the budget columns and then share that spreadsheet. Is there any option like…
-
COUNTIFS and SUMIFS formulas with multiple criteria AND a dynamic date range in a sheet summary
Hi everyone, I've had a look in the forum threads to try and find an answer already, but not sure what I'm trying to do is like-for-like with some of the suggestions. BACKGROUND: I'm helping colleagues with aggregating some of the data in their deployments sheet, which they use for managing and tracking their events, the…
-
Report Creation tool within a sheet
One of my most frequent uses of Smartsheet is as an editorial calendar for a weekly newsletter. I create a new sheet for every month of the year. Exiting a sheet and creating a report is not too much of a hassle but, it would be nice if I could click a button within a sheet that automatically opens a new page that is a…
-
Is there a way to show which reports are built off a sheet?
Hi there, I saw some discussion about this a few years ago, but as an admin, is there any way for me to create a list of reports that use a given sheet as a source? For example, for sheet A, can I pull a list of all reports that use Sheet A as a source? Thanks! Jackie
-
Modified "Report" for client
I have a contract with 262 units that are being reported into 10 database sheets. The finished product I am looking to have is a sheet with the 262 units displayed vertically with the Projects horizontally, with the quantity reported on each project in the row of the corresponding unit. I was successfully creating cross…