-
SUMIF Formula
Working on a project where I want to put a total in a column based on if an asset needs a rehab. I would like for the formula to find the year and if it matches with the column, put the total in that cell. Here's what I've got: =SUMIF([Next Overhaul Year]2:[Overhaul 15]2, =[SFY2021]1, [Dry Dock Cost]@row) Getting an…
-
Link to a Dashboard in an automation alert
I am sending out alerts based on a cell being changed. I would like to customize the email that gets sent to include a link to a related dashboard. Is there a way to make this a hyperlink that can just be clicked to take them to that dashboard?
-
Sorting Rows Ascending Numerically
I right click on the column and select "Sort Rows" and select "Sort Items By" the name of the column. They arrange numerically but it's broken up into numbers 007-099 showing up below 103-180. I want the 007-099 numbers to show up above 103-180 (as it should). My thought is that the numbers are "text"? But I can't find…
-
Formula to calculate next 5 working days only
Hi everyone, I'd appreciate a bit of help here. I have a checkbox which I need to populate with a formula that returns the next 5 days, but doesn't include weekends. I'm currently using this, which is fine, but includes weekend dates. =IF(AND(Start@row <= TODAY(+5), Finish@row >= TODAY()), 1) Many thanks in advance.
-
New multi-select Field functionality, Feedback
I don't like that in resulting Excel dump from Smartsheet that values where I multi-select values, LOVs that resulting Excel filter does not have a space
-
Losing Data & Slow Performance
Hi, just recently my Smartsheet is going really slow, and I'm losing information I've just entered. I can't drag information from one cell to another, and can take 3 seconds or longer to load information, and half the time the file doesn't actually attach. I have to close down and reopen Smartsheet all the time so it saves…
-
Notifications Don't Work
Why aren't my notifications working? I can't seem to get them to send when I make changes in my sheet, but my coworkers get the emails.
-
Dropdown CELLs? Please, oh please
Multi-select dropdown columns is great, but I was hoping that the common community request of having dropdowns specific to cells could happen. I currently have hyperlinks to another sheet, but it isn't ideal. Something like the Data Validation in Excel.
-
Multi-Select Values won't print!?
I used the new Multi-Select function in my sheet and I love it. However, I can't get the second value on the line to print. It's only printing the first value selected. EX: "Responsible" Column: Joe Smith and Jane Numbers were both selected as the responsible individuals for a specific task. On the sheet, they are both…
-
Auto move a Sheet after x# of days of inactivity
Hello, is there a way to set up a workflow or some automation on a sheet what would move it to a designated folder and remove all share permissions after some # of days of inactivity? As an admin, I have a lot of sheets stacking up and would like to either start setting them up with this auto move or have some way…
