-
JOIN function in a Sheet Summary
Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summary (or if I even can do this). This is the function I'm currently using in a column titled Milestone Complete:…
-
sysadmin + groupadmin but cannot edit column properties???
For a sheet where I'm not the owner, but another licensed user in my team is, I cannot edit the column properties. Am I missing something? If not, then this really reduces the collaborative value of Smartsheet Thanks, Arnie
-
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…