Discussion List
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.
Calculate quarter from date
I have a Date Ordered column and want to automatically populate a Quarter column based on the date ordered. What is the best way to write this formula?
How to set default Gannt view Timescale Settings Primary Heading to "Weeks" for all sheet users
How to set default Gannt view Timescale Settings Primary Heading to "Weeks" for all sheet users? Not all users on our project team have a Smartsheet license; they are not able to see the Gannt view with the "Weeks" Timescale Settings Primary Heading. is there a way to default to this for all users of this sheet?
Automatic Date Setting
Hi! I would like to automatically populate a date, based on another one. In the column 'Approved by Committee', I have created an automation for a date to be created when the status changes in another column. This seems to work for now. In the column: 'Date Comprehensive Submission Due', I want to create a formula that…
Default view card or calendar for Teams integration
Hi there, I attempted to see if there was a solution for this out there, but no such luck. Hoping this group may be able to help... I recently integrated some sheets to a Microsoft Teams channel. The sheets in question when shared in Smartsheet are Card view or Calendar view rather than the standard grid. When integrating…
Document Generation/Dynamic Views & Conditional Formatting
How can I set up a generated PDF document to carry over the conditional formatting from my grid? Can the Dynamic View also show the conditional formatting applied to the grid? This works for reports but I haven't been able to figure out how to set the document or view up to show the conditional formatting in the grid...…