-
Using Tables of information in Drop Down Questions in Forms
I 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. Pediatric Hospitalist; Heart Specialist: Heart Surgeon, etc., but there will be many…
-
Form not showing up in list of sheets- but link works
Hello, 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 list of sheets, nor is it located in the "manage forms" section. How is it possible that…
-
Hide Divide by Zero Error
Hello, 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 =IFERROR(AVG(CHILDREN([Column]@row],""))) Thanks so much!
-
SUM cells with formulas not working
Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the second sheet is asking to SUM some of the numbers in the first sheet's column and divide…
-
Deposit summary report vs. bank statements
Hi, We're trying to create the following project. I would appreciate getting some input on how to program it correctly. As a healthcare billing company, we post all account receivables to the patient's ledger. At the end of the month, we need to tie out the deposits posted to the bank statements to confirm that every bank…
-
Formula to change status symbol if a task is not completed before due date
Thanks guys, new to Smartsheet and need some help... Having issues with changing the status symbol to Red, Yellow, Green, or Gray based on project completion percentage column (%Complete) and start/due date columns ("Start Date" / "End Date"). I would like the following: Gray - If %Complete equals to 0 and start date has…
-
COVID-19 Vaccine Tracking and Distribution
Hello Healthcare Community! My name is Brianne and I work as the healthcare vertical program owner in customer success at Smartsheet. Over the last few weeks, we have been seeing an increased number of our healthcare clients having a need for COVID-19 Vaccine Tracking and Distribution planning. What do you need to see in a…
-
Our newest template set, Vaccination Tracking, has just been published to Solution Center!
If you are a healthcare employee we encourage you to join our Healthcare Community Group where updates like this are posted. Details about the new Template Set: Organizations authorized to administer vaccinations during a period of great demand face an uphill battle; the requirement to precisely track, manage, and report…
-
Ensuring Automation Alerts Stay in One E-mail Thread
Hi, We created a variety of automation alerts for our business development team to receive alerts related to the progression of a specific patient through the referral process. Ideally, we would like for the e-mails regarding the same patient to remain in one e-mail thread for organization purposes. I set the subject line…
-
Undoing a sort and reverting to a sort rows by date
Hi! We have a sheet with multiple editors. The first column is an auto generate "Created" column. One of the users sorted a different column and saved. When attempting to sort the created by column ascending so that it reverts to the rows being ordered in the sequential time order in which they were entered, it remains…