Discussion List
Why Portfolio Summary Sheet displaying duplicate rows?
I created a blueprint in Control Center and all was working fine until I updated some columns (adding more values for drop-down list and changing a column to a formula column) in the intake sheet. I think I must of done something that messed up the blueprint because now new provision projects are showing up twice on the…
Hi There, I have a column with comma separated strings. How to find the occurrence of each string?
Please see the below table. I have 20,000 responses. I need to find out how many times each response was given. I have 20000 responses. I need to find out how many times each response was given. Thank You.
IF Formula to assign a symbol depending on where a date is in relation to today's date.
Hi, I'm looking for a formula to indicate where a specific date in one column is in relation to today's date. I have the column where this formula will be input setup as a symbol column to return a color (Red, Yellow, or Green) to indicate the relation between today's date and the date in another column. If the date is in…
Reduce Emails! Please Tweak New Assets Ownership Logic
Can you please make a slight enhancement to the new Assets Ownership Logic? To be clear, our team is in favor of the new Asset Ownership Model – it makes sense and ultimately is a good thing. That said, our team (30+ people) is dealing with an influx of emails because every time an individual requests access to specific…
convert 12 hours time to 24 hour time
Hi, I want to convert 12 hours of time to 24-hour time; kindly help me with this issue.
Formula
I have tried multiple formulas. I am trying to count how many "Assigned" are "Status" (completed, not started, In Progress). I am trying to do this by the person in The Assigned. So, Angie has (2 Not completed, 3 In progress). Can someone help with this.
Formula Question for IF(AND(NOT(ISBLANK(
I have a sheet that contains book information and want to index/match date from another Smartsheet as long as the date in the column called Most Recent Available Date@row is greater than today AND InventoryID@row is not blank. If either of these is not the case, then I just want an empty cell. Here is the formula I…
Adding Countdown Timer widget to Dashboard
As a project/program manager I should be able to add a countdown ticker (go-live countdown) to my dashboards so users can easily track progress. Today there are several convoluted ways to accomplish this, but they really do not work well at best. The proposed widget should simply add the ticker on the dashboard. It should…
More Characteristics in Naming
My company would LOVE if we could get a few more characters for sheet naming. Were always like 3-5 short.
Dark Mode for Desktop App
I'm so pleased to see the release of the Desktop App. Such a key feature, so well done. It would be great to have dark mode included in the app.