-
How to use COUNTIF on a Smartsheet Report
Hello - I have a report that manages all past due, in progress, and upcoming tasks sorted by team member. I am trying to use the COUNTIF formula on my Metric Sheet to count the number of past due tasks by team member in the report. My goal is to use my Metric Sheet to gather the number of past due tasks by team member and…
-
Formula for updating window of time to different time zones...
I am creating a form to schedule meetings however, I need the times I have listed in Pacific Daylight Time (PDT) to be converted into Mountain Daylight Time (MDT) (PDT+1 hour), Central Daylight Time (CDT) (PDT +2 hours), Eastern Daylight Time (EDT) (PDT +3 hours), and Greenwich Mean Time (GMT) (PDT +7 hours). I am manually…
-
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…