-
LookUp and Match a value located in a cell with multiple values and return single and/or multiple va
Hi, I am hoping someone can help with this formula. I was able to get this working using VLOOKUP when there were fewer complexities. In Sheet 2 when there is a value in the "Lot Number" cell, * The formula should look at Sheet 1 to see if the "Lot Number" matches and exists in any of the cells located under the Lot Number…
-
Employee Fit Testing Tracking
I am very new to creating my own smart sheets, I am looking to create a tracking of Employee Respirator Fit Testing. This sheet would need a away to annually updated by testing completion date as well as the type of mask they tested on, noting that some employees with have to complete fit testing on multiple masks each of…
-
Date 6 months out (to the day)
Hello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also new at SS, so I am just now learning syntex, etc., regarding functions and formulas.…
-
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…
