-
Data merge help.
I have a report that I pull monthly. This report has quite a bit of information, but the primary data I am hoping to manipulate is SKU numbers and SKU sales per SKU number. I have created a Data Shuttle as well as a MERGE INPUT SHEET and a MERGE RESULTS SHEET I attach the excel sheets to the INPUT sheet which then triggers…
-
Problem moving rows within a sheet
Hello. I am experiencing problems with a simple select and move of any row within a sheet. In the screenshot below I have highlighted row 2002 and am looking to drag it down to between 2006 and 2007. However it ends up being placed between 2003 & 2004 (where you can see a faint blue shading). This is really annoying as I…
-
Document Generator
I am in the process of designing a daily form that needs to be filled out. However, I'm facing an issue when mapping the form fields to the document generator. Currently, the generated PDF populates the same answer (S, U, or N/A) for all days. My intention is to have the field allow for daily input, with the information…
-
Approval Workflow: Triggered even though condition is NOT met
Workflows: Two different approval workflows currently, see below. Event: When a project is moving from Discovery into Evaluation, an approval is sent requested. If it is Declined, BOTH of the declined branch notifications (the "request for update" in each screen shot below) are triggering, resulting in the PM receiving two…
-
Inventory Request Tracking
Hello, I am trying to set up an inventory request system. I seem to only be able to find templates for request trackers and inventory trackers, not a way to link the two. How can I create an inventory list and then a form where users can request use of items in the inventory and I can track when items are checked in/out…
-
Clarification on Import
Importing feature from another program is possible ?
-
Conditional Formatting is turning my rows red
I am unsure what I did, but there seems to be something wrong with my conditional formatting and now its turning my entire row red when an item is flagged as past due. Does anyone know how to change it?
-
Smartsheet Print Options - Cannot select specific column & Hyperlinks disabled
Hello, Can you please help me with the 2 queries. Has the option been made available to print "Selected Columns". I have to hide the columns first to unselect them from printing which is a manual process When I print, the hyperlinks don't work wherein I added the weblinks to the cell values. The usual hyperlinks which were…
-
How to request Update but filtering by topic?
Hi, I am managing a data base of 10 programs that needs updates on around 20 line items per programs. I would normally use the "form" option but for this particular case I want to ask key contacts for updates but I want them to have a table view where they can cross a box if they have an update for that specific line and…
-
Reusing link on update requests
I have multiple rows being sent to the same user for an update request. All the update requests are linked to a single url. So the user went in and completed 3 of 10 rows, saved and then exited. The link does now not work because Smartsheet thinks the update has been completed, but there's still 7 of 10 that need to be…