-
Grouped reports with multi select dropdowns
This discussion was created from comments split from: Grouped Reports with multi-select dropdowns.
-
Is it possible to clear cell value in a Date column?
I wanted to clear Installation Date column values using Automation. But I couldn't find the column name in Clear cell value action block
-
Need To Figure out a way or a Formula
How do I split the numbers into the same sheet when they are in a same cell like an array which has been brought to that cell using a formula. Eg: i have 182,183,184…. in one cell and I want to split them and create a row for each number on it's own. How do I do that?
-
Disable auto update of start dates for dependent tasks
Looks like there was a thread on this https://community.smartsheet.com/discussion/7262/forced-dates-when-dependency-is-enabled to disable auto-update of start dates when using the predecessor feature.. is this implemented?
-
Sort rows not working correctly in sheet
This discussion was created from comments split from: Problem sorting report based on "Assigned to" (Contact List).
-
Conditional formatting using multiple columns
Hi! I feel like I'm making this harder than it has to be- I have a max inventory column and sold column, and I want to use conditional formatting to make oversold = Red, sold out =Yellow and inventory available =green. I understand I need a helper column, but can't figure out the correct formula.
-
Waterfall charts
I was with a company that they used waterfall charts to explain any month-to-month or year-to-year changes, either actual in the past or projected into the future. These are really hard to build unless the app supports it as a native type.
-
Is Microsoft killing the Outlook Add-in?
Hi all, I was just informed by our I.T. Dept that Microsoft is killing the Outlook Add-in. We use this add-in quite extensively. Is anyone out there aware of a quick and easy way to attach emails to specific rows in specific sheets? It sounds like we have until June when Microsoft will be permanently disabling Legacy…
-
Last working day of the current month
I need some help with the following formula: =WORKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()) + 1, 1) - 1, 0) The formula stopped working this morning, and is now showing #INVALID VALUE instead of the date (I'm expecting 12/31/2025). Can someone tell me what is wrong with the formula that it's not giving me a date?
-
Viewing Full Year in Calendar View
I would love to be able to view a full calendar year in calendar view. (We are a school district so I would want it to show July 1, 2025 to June 30, 2026). I create a Professional Learning Calendar every year and would to start using Smartsheet to do this instead of google sheets. I have transferred all of our PL events…