-
how do you import an excel date/timestamp into smart sheet and have both date/time shown?
I captured date/timestamp in smart sheet 09/17/2020 13:35:44 and loaded this into smart sheet but the loaded value truncated the time, i.e, when loaded smart sheet showed 09/17/2020, but the time stamp was lost (truncated off). How can i also get the time stamp to be loaded, either in the same field or a departe field?
-
Form from one sheet populates another sheet
Hello SS gurus, I am relatively new to SS "in the field", although I've watched over 20 hours of videos from the SS Learning Center so I have a good understanding of the mechanics. Here is what I'm trying to do... We need to track inventory in our supply room: items on hand, items removed, items added, etc. We would prefer…
-
Find all similar entry names and add their qty
Hello I have a sheet I made where I load in all my orders of items needed for a job. Each Item has a code assigned to it I'm calling the Entry Name. There will be times where the same Code/Entry Name will appear several times during the life of the project. For Example This week I might need 4 - BT01 (Entry Name) then as…
-
Cannot transfer ownership of Smartsheet Calendar
I am trying to transfer ownership of a Smartsheet Calendar to a coworker, but when I try, it is giving me an error message, saying that the user isn't found and new user needs to be shared to the source sheet/report as an Admin in Smartsheet. I have checked, and this coworker is already an admin in all of the source…
-
Send Scheduled Report ONLY to Assigned To resources
I have a Report I would like to send out in PDF format weekly, but only to users who have an entry in the worksheet assigned to them. The report is pulling from a RAID Log, and is configured for Current User. The challenge I am facing is that I don't know how to get around having the Scheduled Report sent to a static…
-
Possible to one file in multiple workspaces?
Hello, Is it possible to have a smartsheet and reports in multiple workspaces? I'm creating a separate workspace for a different team that will need access to the master document which resides in another workspace. The first workspace has some additional reports that I do not want to provide access to. Please advise.…
-
Download workspace sharing report (csv) is not working
Hello Team, I am not receiving any emails to download my workspace report. I tried this multiple times in last 3 hours. Can you please revert back? Thanks
-
IF Statement w/Drop-down Multi-select
Hi folks, I'm trying to create a formula focused on two columns (one a single-select drop-down and the second a multi-select drop-down). Based on the value in the single-select drop-down, I'd like the multi-select column to include multiple selections. My attempt at the formula is below: =IF([Change Requested]@row = "New…
-
How to Use VLOOKUP and SUMIFS
I have 2 sheets. The first one is for case reviewer #1. It lists the case ID and the hours each day they worked on it. In total I have 3 reviewers and each have their own time sheet. Then, I have a summary sheet that lists the Case ID, each reviewer, and then the total time spent on each case. What I would like to do is on…
-
Formula to Forecast Material Quantity Received vs Consumed
I am hoping there is a formula to see what I will need to forecast to purchase for material received vs consumed. Any help would be greatly appreciated!
