-
Our newest template set, Vaccination Tracking, has just been published to Solution Center!
Organizations authorized to administer vaccinations during a period of great demand face an uphill battle; the requirement to precisely track, manage, and report on individual records, while facilitating a high-volume request intake process, is unprecedented. With the Vaccination Tracking template set, organizations can…
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
Currently having trouble counting data in a multiselect cell.
Here is my currently formula, and it works to count if there is one lab with a value, but I need it to be able to count if there are multiple labs with Moderate in the cell. For example, I could have XXX-Moderate, AAA-Moderate, BBB-Waived, CCC-High. Right now the formula would only return 2 when it would be 3.…
-
Vaccination Status/Testing Report
Does anyone have an easy solution to tracking employee weekly testing? My thought is that any employee that shows as unvaccinated will receive an alert each week to upload their test results. (I don't have a problem setting that up). From there, if an employee doesn't upload the test results each week then an alert will be…
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Recommended format
Hi there, I'm looking to track daily activities of field staff. This involves broadly tracking daily tasks but perhaps more importantly location of staff in the field (who is where and when) and the work vehicle they are using (we have about 13 that are shared among staff). How would you recommend approaching this? Thank…
-
Outlook Integration not installing
Inside of Outlook, I have clicked "Store Add-ins", found "Smartsheet for Outlook" and clicked that. I then clicked the blue "Add" button. This then briefly changes to "Adding..." then to "Added". When I go into my Outlook email list, there is no Smartsheet icon. When I go back into "Store Add-ins" and find "Smartsheet for…
-
I'm trying to create a form to be used to evaluate if a product is acceptable or not.
I'm trying to create a form in Smartsheet that would look similar to this below. Is this even feasible at this point with Smartsheet? First column is the product being evaluated, and we are asking clinicians to check either acceptable or not.
-
How to if statement for more than one cell ?
How to if statement for more than one cell ? What I have is three cells with dates and I want the sheet to check if there is a date in the 3rd cell to count from that date if not to check the second and if not to check the first cell
-
Filter by color
Is it possible to filter a column by color? We use visual management extensively for some of our larger enterprise projects and filtering by color is helpful. I didn't see a way, not sure if there was a "trick".
