Healthcare
Discussion List
-
Annual Calendar by Day TemplateIn Using SmartsheetHi, We used the Annual Calendar by Day Template and it works great for the current year. However, we want to continue using the sheet in 2019 below the current year. When I copy the rows to below the current calendar, the formula is not ea…
-
% Variance between 2 numbersIn Formulas and FunctionsI am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?
-
Need Formula: Per Facility per Model #, how much +/- from par level.In Formulas and FunctionsI need to add a column formula within the Stock Inventory Sheet, in the Qty. Above/Below Par column, that calculates per Facility per Model #, take the quantity from Order Type Stock Order Row – Facility Specific Part(s), how much above or…Answered - Pending Review 21 views 5 comments 0 points Most recent by Mark Cronk Formulas and Functions
-
Dropdown Multi select - ~If formulaIn Formulas and FunctionsHi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few column…
-
Is there a way to download SmartSheet form as a PDF?In Using SmartsheetI want to be able to use Smartsheet form as a PDF also in cases where I have to manually write information or use the form as a Job Sheet for Complaint/Servicing form. How can I do that? Any help will be greatly appreciated.
-
Using Tables of information in Drop Down Questions in FormsIn Using SmartsheetI want to collect information from all physicians in our hospital. One of the drop down questions on the Form is Describe your role? It is not a freeform question. I want their drop-down choices to be the type of doctor they are, e.g. …
-
Form not showing up in list of sheets- but link worksIn Using SmartsheetHello, I created a form for people to confirm they've read my info. Sent the link to the form. The link works for me, I've received confirmation that I've used the form. But when I log into my account, the form does not show up on the lis…
-
Hide Divide by Zero ErrorIn Formulas and FunctionsHello, I am having issues with creating the correct formula that calculates the average of the children rows while hiding the divide by zero errors for columns that do not have any data. Could someone please help? I tried the following…
-
Flagging a Date and Time OverlapIn Formulas and FunctionsHello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as…
