-
Card View Details Window - Make it non-modal
Please make the details window in card view non-modal. That is, make it so that it docks to the right-side of the screen and stays open while I click through my cards in the other part of the view. This would bring your details pane up to par of what Asana and Jira have available. Currently the detail window is modal and…
-
Hello fellow Healthcare & Life Sciences folks!
I am newer to the Healthcare Industry, but I love it. I am the Administrative Assistant at our corporate office. We have 13 free-standing Emergency Rooms, and 1 Urgent Care facility. I am the creator and implementor of all things SmartSheet for our company, all facilities use the forms and audits we have. Sometimes when I…
-
Basic Formula
Two different equations are being used. Equation 1: =IFERROR((SUM([RN Section 1 Score]@row, [RN Section 2 Score]@row, [RN Section 3 Score]@row, [RN Section 4 Score]@row)) / SUM(IF([RN Section 1 Score]@row = "-", 0, 0.3), IF([RN Section 2 Score]@row = "-", 0, 0.3), IF([RN Section 3 Score]@row = "-", 0, 0.2), IF([RN Section…
-
Today's Date in a Dashboard
Hi, I have recently gotten into using Dashboards within Smartsheet, amazing. Is there a way to display today's date in a widget? Thank, Scott
-
Remove all hierarchy (indents) from a sheet
Hi, I have a sheet with about 500 rows, with a lot of hierarchy (indents) within it. My ultimate goal is to be able to sort rows by one of my columns, and not have the indents alter how the rows are arranged after this sorting. Therefore I planned to create a new sheet where I removed all the hierarchy/indents (sort of…
-
Is the Email Notification highlight color yellow definable?
In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
-
Formula linking one column to another sheet; =IF(ISBLANK) function
Hi all! I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) function to display whether these records are "Complete" or if left blank in sheet one, "Incomplete". I have tried using the…
-
Send only Columns in row with data when sending Notification
Any way to, when sending notifications on a row being added or edited, omit columns that have no data? Say I had an order form with 100+ possible items on it. I don't want to send a 5 page email detailing all the items the person did and didn't order, I want to have the notification only include the handful of items the…
-
Daily Automated Report
I am a dead beginner with SmartSheets and I am self taught thus far so explain to me like I've never seen a computer before :) Our hospital holds daily huddles where each department reports out on questions specific to their unit (current paper form attached). I’ve created a sheet that includes all the questions to be…
-
Count formulae
Hi all, Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations: To calculate the count of 'Medical Device Related' category from the 'Relevant System' column Same as the above but for 'Non-Medical Related' category I want to have a breakdown of the sub-categories for each…