-
Automatically copy the dropdown list choices to other columns.
Hello, We use Smartsheet for the management of our timesheets. As in the same day, an employee can work on different projects, we have created several numbered columns allowing to associate hours in different cost center/projects. The type of column being Dropdown list, when we want to add a cost center or a project to the…
-
Some rows hidden from my view but not others
Hi There, I have an issue where I enter date on the sheet, save it, and then come back and it's hidden. It's visible when exported to excel, but the rows will jump from 24 to 36, with in between rows not showing. Any help on how I could fix this??
-
Dashboard issues
Hi SS community…. One of the biggest pain points for my team and myself is the space that is wasted on dashboards. When You display reports and Dynamic calendars etc. and the lines reported in the widget do not fill the space at that moment it leaves a ridiculous amount of empty space which for a dashboard does not bode…
-
If/And formulas
Hello All, I am trying to create a formula where I want to see the sum of all positive test results if the testing date is within the last week. This is what I have so far and not sure if I am even on the right track. =SUMIF(AND({Employee Surveillance Testing Range 1}, >0, {Employee Surveillance Testing Range 4} - TODAY()…
-
End Date Calculation
Hello, I currently have a project that typically runs overnight (pm to am) and time calculations are based on an end date that is the install date + 1 day. I need to figure out a calculation for when the installation is not overnight (i.e. 8:00 pm to 11:30 pm) Below is the current formula. =IF([Tech Name]@row > "",…
-
Can I link entire columns of two project sheets ?
Hi all , I would like to explain my concerns . I want to know if it is possible to link columns of two project sheets ( one is the schedule baseline and the other is the actual schedule ) , so that when I populate information in the actual sheet columns , there is a change in the baseline sheet columns . This is how I…
-
Sheet kicks me out after a couple minutes
I am the admin and owner of my smart sheet and I have been trying to add some new columns in. After a couple minutes it boots me out with no warning. I get the error "you smartsheet is no longer active" and then I have to log back in. I am using Chrome and only have a few columns in the sheet so it shouldn't be over…
-
Link Barcodes to rows
Hello All Is there a way to link barcodes to a specific row in smartsheet? For example: I have a lot of details that needs to be installed. A worker takes his phone or barcode scanner, scans the specific code and gets info from a smartsheet table, about what detail is this etc.? Thank you in advance Sander
-
Require assistance in Integration of Task list + alert + calendar
Need your assistance in the following matter: 1. Task list ( That contain tasks for multiple employees ) 2. Automated reminder should go on task based that too the concerned employee 3. Need to configure "Task list", " Automated reminder" and Calendar (i.e. Google calendar) So technically, we want a single sheet that…
-
Signature required
Hi, I have a sheet with rows that act as work instructions to people out in the field. I attach various documents they need to do their jobs together with location and a map etc. I now need to add a client physical signature somehow and I don't know how to accomplish it. I don't want them to have to print a piece of paper…
