-
Need Formula: Per Facility per Model #, how much +/- from par level.
I 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 below are we from the Par Level? So something along these lines: Per Facility, Per…
-
Dropdown Multi select - ~If formula
Hi 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 columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
Is there a way to download SmartSheet form as a PDF?
I 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 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…
